From: Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Distinct oddity
Date: Tue, 12 May 2009 20:29:36 +0200
Message-ID: <C62F8CB0.360D2%maximilian.tyrtania@onlinehome.de> (raw)
In-Reply-To: <20090512172357.GC4050@alvh.no-ip.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maximilian.tyrtania@onlinehome.de, alvherre@commandprompt.com
Subject: Re: Distinct oddity
In-Reply-To: <C62F8CB0.360D2%maximilian.tyrtania@onlinehome.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox