Some more facts illustrated at a small example:

String URL = "jdbc:firebirdsql:<host>:<path_to_db>";

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

Connection conn = DriverManager.getConnection(URL, "sysdba",
"masterkey");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT LANGUAGE, CONTENT from
TEXT_R where ID = '65:13:24:2:mixedtext'");
rs.next();
System.out.println(rs.getString(2));

rs.close();
stmt.close();
conn.close();

If I run this on Windows everything is fine. If I run it on Linux the
query returns a "?" instead of the umlaut character.

Any help appreciated!

Greetings, Christian

Christian Schacht wrote:

> Hi there!
>
> I have a problem reading special characters (like german umlauts) from
> the interbase database via jdbc. (No problem with isql)
>
> Special characters like german umlauts (äöü, etc.) are replaced with
> the character '?' under Linux.
>
> This a a tomcat 4.1.24 based web-application. When I run my App on
> Tomcat/Windows against the same firebird Linux-instance there's no
> problem. So I blame the driver and imagine the driver needs something
> on the system to be able to return these characters? The database,
> table and column have character set "NONE".
>
> I also tried to set the character set via "?lc_ctype=UNICODE_FSS" but
> received an unrecognized transaction error.
>
> Any ideas?
>
> Greetings, Christian
>