Date: Tue, 12 May 2009 13:23:57 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Distinct oddity
Message-ID: <20090512172357.GC4050@alvh.no-ip.org>
References: <20090511143826.GB8689@alvh.no-ip.org>
	<C62F72E1.360C4%maximilian.tyrtania@onlinehome.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <C62F72E1.360C4%maximilian.tyrtania@onlinehome.de>
User-Agent: Mutt/1.5.18 (2008-05-17)

Maximilian Tyrtania wrote:
> 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?

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.

What platform are you using anyway?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.