Re: Troubles using German Umlauts with JDBC

Alexander,

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

Properties props = new Properties();
props.put("user",user);
props.put("password",password);
props.put("charSet",encoding);
Connection con = DriverManager.getConnection(url,props);
where encoding is the proper encoding for your database

Dave
On Tue, 2001-09-04 at 09:16, Alexander Troppmann wrote:
> Hi,
>
>   we have troubles with German umlauts (e.g.: äüÖ) using the Postgresql JDBC
>   driver form the 7.1.2 distribution... already tried to debug our Java
>   software but it seems that the database driver modifies the umlauts in any
>   way - a debug before any INSERT or after a SELECT query shows that the
>   umlaut "ü" for example gets lost on the way though the JDBC driver...
>
>   So e.g. the attribute city='München' gets "M\?nchen" when testing the JDBC
>   driver using a simple Java program.
>
>   Any idea what happens?
>
>   Best regards,
>   Alex T.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>