Subject Re: [firebird-support] Cannot transliterate character between character sets
Author David Johnson
On Tue, 2005-03-29 at 12:45 +0000, Thiago Costa wrote:
> When the lc_ctype is not set, the query runs without erros, but when
> the lc_ctype=ISO8859_1 is set a have the flowing exception:
>
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321.
> arithmetic exception, numeric overflow, or string truncation
> Cannot transliterate character between character sets
>

Refer this to the jaybird mailing list. It looks like a bug to me.

For a workaround, set the character set to none (don't set it), and do
any character set conversions in your app (see ny last posting for an
example). Depending on your JVM, you may need to make sure the i18n jar
file is on your boot class path.