problems with german umlaut

Rico · **Joined:** Mon Mar 01, 2004 3:29 am **Posts:** 3

Hi all,

I use firebird as database and have problems when I save something with german specific letters like umlauts. The following exception occurred:

Code:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets

I tried something to solve this problem, for example:

1. used system property -Dfile.encoding=ISO-8859-1
2. set a specific firebird property to Configuration:

Code:

Configuration cfg = new Configuration();
cfg.setProperty("lc_ctype", "ISO8859_1");

But all this doesn't helped.

The database table's itself are created with a charset of ISO-8859-1 and I have no problems to add data with german umlauts in a database tool like IBExpert.

Has anybody an idea ?

Thanks in forward
Rico

Rico · **Joined:** Mon Mar 01, 2004 3:29 am **Posts:** 3

Ok OK, if nobody help me I have to help me myself. If somebody is interesting in, something helped me:

Code:

Class.forName("org.firebirdsql.jdbc.FBDriver");

Properties dbprop = new Properties();
dbprop.setProperty("user", "sysdba");
dbprop.setProperty("password", "masterkey");
dbprop.setProperty("lc_ctype", "ISO8859_1");

conn = DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:C:/db.gdb", dbprop);

Configuration cfg = new Configuration();
cfg.addClass(Foo.class );
...
SessionFactory sessions = cfg.buildSessionFactory();
setSession(sessions.openSession(conn));

Bye bye
Rico

anthony · **Posted:** Sun Mar 28, 2004 4:03 am

Rico,
hibernate team is working on next release, they continue helping us in the forum but have less time, just be patient...

christian · **Posted:** Sun Mar 28, 2004 6:28 am

hibernate.connection.lc_type = "ISO8859_1"