Re: Troubles using German Umlauts with JDBC - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Troubles using German Umlauts with JDBC
Date
Msg-id 999611669.1171.7.camel@inspiron.cramers
Whole thread Raw
In response to Troubles using German Umlauts with JDBC  ("Alexander Troppmann" <talex@globalinxs.de>)
Responses Re: Troubles using German Umlauts with JDBC  (Rene Pijlman <rene@lab.applinet.nl>)
List pgsql-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)
>
>




pgsql-jdbc by date:

Previous
From: Quentin DELANCE
Date:
Subject: Re: RE : ? (question mark) characters
Next
From: Ian Wehrman
Date:
Subject: jdbc ResultSetMetaData::isWritable()