Subject Re: [Firebird-Java] (unknown)
Author Helen Borrie
At 07:31 PM 11/04/2004 +0000, you wrote:
>I'm from germany and so I have to handele chars like ä, ö or ü in my
>Java Applications.
>But If I search some Records with a Prepared Statement like this:
>stm = conn.prepareStatement("Select " + field + " From " + table + "
>Where upper(" + field + ") starting with upper(?)");
>and set any String with one of the chars ä, ö or ü I get this
>org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321.
>arithmetic exception, numeric overflow, or string truncation
>Cannot transliterate character between character sets
> at org.firebirdsql.jdbc.FBCachedFetcher.<init>
>What can I do to fix this or is this not fixable?

1. Define your database to have the default character set ISO8859_1. That
will make the character-encoding in the database compatible with text data
that is input in German (and many other European languages). You can use
COLLATE DE_DE for specific columns where you want to search on upper(),
German dictionary ordering and other locale-specific attributes
2. Connect your client to the database using lc_ctype of ISO8859_1 so that
the client can reassure the server that it is receiving correctly-encoded
3. Read the FAQs for more information.