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

From Thomas Kellerer
Subject Re: getTables() doesn't handle umlauts correctly
Date
Msg-id icmlpr$jcl$1@dough.gmane.org
Whole thread Raw
In response to Re: getTables() doesn't handle umlauts correctly  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Kris Jurka wrote on 24.11.2010 08:43:
> 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?

encoding: UTF-8
lc_collation: German_Germany.1252
lc_ctype: German_Germany.1252


>\l output from psql would be useful.

                                            List of databases
     Name     |  Owner   | Encoding |      Collation      |        Ctype        |   Access privileges
-------------+----------+----------+---------------------+---------------------+-----------------------
  thomas      | thomas   | UTF8     | German_Germany.1252 | German_Germany.1252 |


For completeness:

                            version
-------------------------------------------------------------
  PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 32-bit
(1 row)

JDBC driver: PostgreSQL 9.0 JDBC4 (build 801)


Regards
Thomas

pgsql-jdbc by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: [HACKERS] JDBC and Binary protocol error, for some statements
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] JDBC and Binary protocol error, for some statements