Postgres Pro
Downloads
Home   >   mailing lists

Re: getTables() doesn't handle umlauts correctly - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: getTables() doesn't handle umlauts correctly
Date
Msg-id 4CECC215.7030401@ejurka.com
Whole thread Raw
In response to Re: getTables() doesn't handle umlauts correctly  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: getTables() doesn't handle umlauts correctly  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc
Tree view 
On 11/23/2010 6:22 AM, Thomas Kellerer wrote:
> table name: umlaut_test_�
>    codepoints: 117 109 108 97 117 116 95 116 101 115 116 95 65533
> number of rows: 1
> data: öäü
>    codepoints: 246 228 252
>

I can reproduce this, but only with databases that have a mismatched
encoding and ctype/collation.  That's supposed to be tough to mess up
now, so I was only able to do it on older server versions.  What do you
have for encoding, lc_collation, and lc_ctype?  \l output from psql
would be useful.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Radosław Smogura
Date:
Subject: JDBC and Binary protocol error, for some statements
Next
From: Thomas Kellerer
Date:
Subject: Re: bit datatype and getObject()