I was trying to define some of that information and as it is new to me I
am not 100% sure I got it all correct.

I tried to create the database like this...

Create database '\path\database.fdb' user 'SYSBDA' password 'masterkey'
default character set ISO8859_1;

And then the connection url ...

jdbc:firebirdsql:localhost/3050:/path/database.fdb?LC_CTYPE=ISO8859_1

Is there something more that I should have done to set the character
set?

Jon

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of Roman Rokytskyy
Sent: Monday, February 20, 2006 9:46 AM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] Firebird 1.5/Hibernate 2.0

> I have a table with a column that is VARCHAR(300), let's call it NAME,
> when I do a search on that column (programmatically, but not

manually),

> I always get back an exception ...
> ....
> Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
> 335544321. arithmetic exception, numeric overflow, or string

truncation

> ...
> With further testing, it seems that I only get this exception when

there

> is a row in the table that has a NAME that is greater than 80
> characters.
> ....
> Any ideas on what is going wrong?

How did you define your character sets for column, database and your
connection? Can it be that you have no character set defined for the
database or column (or it is 1-byte charset like ISO8859-1 or one of
WIN12XX
charsets) and your connection charset is UNICODE_FSS?

Roman




Yahoo! Groups Links