Hello,

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
Exception:

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>
(FBCachedFetcher.java:126)
at org.firebirdsql.jdbc.FBResultSet.<init>
(FBResultSet.java:145)
at org.firebirdsql.jdbc.AbstractStatement.getCachedResultSet
(AbstractStatement.java:560)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery
(AbstractPreparedStatement.java:118)
at jlresurces.swing.cbox.AutoComboBox.run
(AutoComboBox.java:182)
at java.lang.Thread.run(Thread.java:534)
at org.firebirdsql.gds.GDSException: arithmetic exception, numeric
overflow, or string truncation
Cannot transliterate character between character sets
at org.firebirdsql.jgds.GDS_Impl.readStatusVector
(GDS_Impl.java:1756)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1709)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_fetch
(GDS_Impl.java:1074)
at org.firebirdsql.jca.FBManagedConnection.fetch
(FBManagedConnection.java:801)
at org.firebirdsql.jdbc.AbstractConnection.fetch
(AbstractConnection.java:932)
at org.firebirdsql.jdbc.FBCachedFetcher.<init>
(FBCachedFetcher.java:63)
at org.firebirdsql.jdbc.FBResultSet.<init>
(FBResultSet.java:145)
at org.firebirdsql.jdbc.AbstractStatement.getCachedResultSet
(AbstractStatement.java:560)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery
(AbstractPreparedStatement.java:118)
at jlresurces.swing.cbox.AutoComboBox.run
(AutoComboBox.java:182)
at java.lang.Thread.run(Thread.java:534)

What can I do to fix this or is this not fixable?

Thank you