Subject Re: [Firebird-Java] Re: Exception reading data
Author mebus@gmx.de
Thanks for your answer!

> > java.SQLException: fetch problem: org.firebirdsql.GDSException:
> > arithmetic exception, numeric overflow, or string truncation
> > Cannot transliterate character between character sets
> > ...
> > Any idea? Is that a problem with character encoding?
>
> Yes, it is. You have to specify character encoding for a connection.
> This is lc_ctype property for a DriverManager case.
>

But the following coding does not help:

Properties properties = new Properties ();
properties.put("user", "sysdba");
properties.put("password", "masterkey");
properties.put("lc_ctype", "ISO8859_1");

The exception I get is still the same.

I set this properties before writing and reading.

Is this correct for Germany?

Do I need any changes to the database?

Best Regards
Hans Georg

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net