Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    9

    Question Unanswered: Problems with German umlauts ( ) and JDBC

    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: "hllo" -> "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

  2. #2
    Join Date
    Jun 2004
    Posts
    9

    The answer was blowing in the wind

    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •