User-Agent: Microsoft-Entourage/11.4.0.080122
Date: Tue, 12 May 2009 20:29:36 +0200
Subject: Re: Distinct oddity
From: Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
To: Alvaro Herrera <alvherre@commandprompt.com>
CC: <pgsql-sql@postgresql.org>
Message-ID: <C62F8CB0.360D2%maximilian.tyrtania@onlinehome.de>
Thread-Topic: [SQL] Distinct oddity
Thread-Index: AcnTL5on2HtNDj8iEd6dnAAjMt4/tA==
In-Reply-To: <20090512172357.GC4050@alvh.no-ip.org>
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

am 12.05.2009 19:23 Uhr schrieb Alvaro Herrera unter
alvherre@commandprompt.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