Re: getTables() doesn't handle umlauts correctly

From: Kris Jurka <books(at)ejurka(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: getTables() doesn't handle umlauts correctly
Date: 2010-11-24 07:43:17
Message-ID: 4CECC215.7030401@ejurka.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2010-11-24 08:00:58 Re: bit datatype and getObject()
Previous Message Radosław Smogura 2010-11-24 07:07:07 JDBC and Binary protocol error, for some statements