From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Maximilian Tyrtania <maximilian(dot)tyrtania(at)onlinehome(dot)de> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Distinct oddity |
Date: | 2009-05-12 17:23:57 |
Message-ID: | 20090512172357.GC4050@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Maximilian Tyrtania wrote:
> am 11.05.2009 16:38 Uhr schrieb Alvaro Herrera unter
> alvherre(at)commandprompt(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Maximilian Tyrtania | 2009-05-12 18:29:36 | Re: Distinct oddity |
Previous Message | Maximilian Tyrtania | 2009-05-12 16:39:29 | Re: Distinct oddity |