Re: Distinct oddity

am 12.05.2009 19:23 Uhr schrieb Alvaro Herrera unter
alvherre(at)commandprompt(dot)com:

>> 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?
>
> Hmm, I didn't expect this. I guess I assumed de_DE was an alias for
> the Latin1- or Latin9- encoded locale, but it seems your system uses it
> as an alias for the UTF-8 encoded one. So my initial comment seems to
> be wrong as well. Please paste the output of the "locale" command.

Sputnik-Server:~ administrator$ locale
LANG=
LC_COLLATE="C"
LC_CTYPE="C"
LC_MESSAGES="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_ALL="C"

> What platform are you using anyway?

Mac OS 10.4.11

Best,

Maximilian Tyrtania