User-Agent: Microsoft-Entourage/11.4.0.080122
Date: Tue, 12 May 2009 18:39:29 +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: <C62F72E1.360C4%maximilian.tyrtania@onlinehome.de>
Thread-Topic: [SQL] Distinct oddity
Thread-Index: AcnTIDgTdq91tD8TEd6KhgAjMt4/tA==
In-Reply-To: <20090511143826.GB8689@alvh.no-ip.org>
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

am 11.05.2009 16:38 Uhr schrieb Alvaro Herrera unter
alvherre@commandprompt.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