Maximilian Tyrtania wrote: > am 11.05.2009 16:38 Uhr schrieb Alvaro Herrera unter > alvhe...@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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
