Re: Distinct oddity

am 10.05.2009 4:58 Uhr schrieb Alvaro Herrera unter
alvherre(at)commandprompt(dot)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