Subject Re: [Firebird-Java] Firebird 1.5/Hibernate 2.0
Author Roman Rokytskyy
> 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?