Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group