Re: Distinct oddity

am 11.05.2009 16:38 Uhr schrieb Alvaro Herrera unter
alvherre(at)commandprompt(dot)com:

>>>Note that the de_DE locale uses Latin9 encoding, which is incompatible
>>>with UTF8.
>>> 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?
>
> Well, either that, or create a new database with Latin9 encoding.

FAKDB=# CREATE DATABASE "TestLatin9"
FAKDB-# WITH ENCODING='LATIN9'
FAKDB-# OWNER=postgres;
ERROR: encoding LATIN9 does not match server's locale de_DE
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.
FAKDB=#

Now i'm deeply confused...So do i have to re-initdb?

Best,

Maximilian Tyrtania