var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problems with German umlauts (ä ö ü ) and JDBC
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:
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
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
The answer was blowing in the wind
Hi found the solution today :-) There are 2 possibilities.
1. Use PreparedStatements
2. Use the JDBC drivers shipped with Pervasive.SQL V8 (they are backwar compatible,thus they work with Pervasive.SQL 2000 too)