Subject RE: [Firebird-Java] Firebird 1.5/Hibernate 2.0
Author Sturdevant, Jonathon
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 ...


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


-----Original Message-----
[] On Behalf Of Roman Rokytskyy
Sent: Monday, February 20, 2006 9:46 AM
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
> I always get back an exception ...
> ....
> Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
> 335544321. arithmetic exception, numeric overflow, or string
> ...
> With further testing, it seems that I only get this exception when
> 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
charsets) and your connection charset is UNICODE_FSS?


Yahoo! Groups Links