Re: Troubles using German Umlauts with JDBC

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: Alexander Troppmann <talex(at)globalinxs(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Troubles using German Umlauts with JDBC
Date: 2001-09-04 13:54:27
Message-ID: 999611669.1171.7.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(at)postgresql(dot)org)
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Doug McNaught 2001-09-04 14:46:12 Re: Fw: Random strings
Previous Message Tom Lane 2001-09-04 13:50:49 Re: Bytea/Base64 encoders for libpq - interested?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gunnar Rønning 2001-09-04 14:32:26 Re: Need help with JDBC driver. Problem, - getExportedKeys
Previous Message andy 2001-09-04 13:50:57 Re: JAVA vs PERL : PERL wins to postgreSQL