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 18:39:29 +0200
Message-ID: <C62F72E1.360C4%maximilian.tyrtania@onlinehome.de> (raw)
In-Reply-To: <20090511143826.GB8689@alvh.no-ip.org>
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
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: <C62F72E1.360C4%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