Re: getTables() doesn't handle umlauts correctly

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