Hi there,

I am using Pervasive.SQL 2000 Server SP 4 on W2K both on Server and Client.

Im trying to insert Java Strings into a table. The problem is, if the String contains a german umlaut just like 'ä' 'ö' 'ü' or 'ß' it appears in the DB only as '?'. Example: "hällo" -> "h?llo"

If I do that using the SQL Data Manager of the Control Center I don't have that problem. Even if I read the String via the Java application the umlauts appear as expected.

The JDBC url for the db connection is like:
jdbc:pervasive://dbhost:dbhostport/dbname"

Note that I can retrieve umlauts via JDBC if they were inserted via the SQL Data Manager. I tried some different codepages e.g. cp850 but it doesn't help

(jdbc:pervasive://dbhost:dbhostport/dbname;encoding=cp850)

In fact if I use cp850 it's not possible to retrieve umlauts via JDBC (but it works to retrieve umlauts in Strings that are stored in Btrieve files)

Who can help me ?

After all: what must I do to store Strings containing umlauts (with JDBC) ?

Thanks in advance

Hi found the solution today :-) There are 2 possibilities.

1. Use PreparedStatements
or
2. Use the JDBC drivers shipped with Pervasive.SQL V8 (they are backwar compatible,thus they work with Pervasive.SQL 2000 too)