Re: getTables() doesn't handle umlauts correctly - Mailing 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