Skip site navigation (1) Skip section navigation (2)

Locale / Encoding mismatch

From: Naz Gassiep <naz(at)mira(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Locale / Encoding mismatch
Date: 2008-03-30 17:32:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I have just attempted to upgrade to 8.3.1 and I now get this error when 
trying to create a UTF8 DB:

postgres(at)mrnaz:~$ createdb twerl -E utf8
createdb: database creation failed: ERROR:  encoding UTF8 does not match 
server's locale en_AU
DETAIL:  The server's LC_CTYPE setting requires encoding LATIN1.

I have never bothered with the server's locale, all the locale handling 
in the app gets handled within the DB itself. I guess I now have to dig 
into the murky world of system locales and how they affect my app 
ecosystem. I don't suppose there is an easy solution to this and a short 
explanation of why it now occurs is there?


pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2008-03-30 18:01:58
Subject: Re: Locale / Encoding mismatch
Previous:From: A. KretschmerDate: 2008-03-30 17:29:22
Subject: Re: Re: [GENERAL] postgreSQL multithreading

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group