Troubles using German Umlauts with JDBC 
Author Message
 Troubles using German Umlauts with JDBC

[forwarding to pgsql-hackers and Bruce as Todo list maintainer,
see comment below]

[insert with JDBC converts Latin-1 umlaut to ?]

>You have to set the encoding when you make the connection.

>Properties props = new Properties();
>Connection con = DriverManager.getConnection(url,props);
>where encoding is the proper encoding for your database

For completeness, I quote the answer Barry Lind gave yesterday.

"[the driver] asks the server what character set is being used
for the database.  Unfortunatly the server only knows about
character sets if multibyte support is compiled in. If the
server is compiled without multibyte, then it always reports to
the client that the character set is SQL_ASCII (where SQL_ASCII
is 7bit ascii).  Thus if you don't have multibyte enabled on the
server you can't support 8bit characters through the jdbc
driver, unless you specifically tell the connection what
character set to use (i.e. override the default obtained from
the server)."

This really is confusing and I think PostgreSQL should be able
to support single byte encoding conversions without enabling

To the very least there should be a --enable-encoding-conversion
or something similar, even if it just enables the current
multibyte support.

Bruce, can this be put on the TODO list one way or the other?
This problem has appeared 4 times in two months or so on the
JDBC list.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Sun, 22 Feb 2004 01:16:39 GMT
 [ 1 post ] 

 Relevant Pages 

1. oracle jdbc and german umlauts

2. INFORMIX and german "umlaut"

3. lower does not handle german umlaut

4. WebDB: German umlauts problem

5. German Umlauts and ISQL

6. oas+jservlets and german umlauts

7. ODBC, SQL and german umlauts

8. german umlaut signs false representation after read from SQL2000 database

9. German umlauts

10. german umlauts in SQL*plus/Windows w/ WE8PC850 charset

11. DTS Import, German Umlaut, ignor some characters

12. Trouble with ODBC and German modified vowels

Powered by phpBB® Forum Software