From: Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Distinct oddity
Date: Mon, 11 May 2009 08:28:45 +0200
Message-ID: <C62D923D.35F9B%maximilian.tyrtania@onlinehome.de> (raw)
In-Reply-To: <20090510025822.GD5365@alvh.no-ip.org>
am 10.05.2009 4:58 Uhr schrieb Alvaro Herrera unter
alvherre@commandprompt.com:
>>> and what locale are you running in?
>>
>> lc_collate | de_DE
>> | Shows the collation order locale.
>> lc_ctype | de_DE
>> | Shows the character classification and case conversion locale.
>>
>> The encoding is UTF-8.
>
> Note that the de_DE locale uses Latin9 encoding, which is incompatible
> with UTF8.
Ah, good catch.
> I'd try checking if the problem is reproducible in
> de_DE.utf8 (you need to create a new database for testing, obviously).
Wait a minute. I need to re- initdb with de_DE.UTF-8, don't I?
> If it's not, then the incompatible locale definition is causing the
> problem.
I'll try that, thanks.
M
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maximilian.tyrtania@onlinehome.de, alvherre@commandprompt.com
Subject: Re: Distinct oddity
In-Reply-To: <C62D923D.35F9B%maximilian.tyrtania@onlinehome.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox