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