Skip site navigation (1)
Skip section navigation (2)
I have just attempted to upgrade to 8.3.1 and I now get this error when trying to create a UTF8 DB:
Peripheral Links
Header And Logo
|
Site Navigation
Locale / Encoding mismatch
- From: Naz Gassiep <naz(at)mira(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Locale / Encoding mismatch
- Date: Mon, 31 Mar 2008 04:32:16 +1100
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 utf8createdb: 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?
- Follow-Ups:
- Re: Locale / Encoding mismatch
- From: Zdenek Kotala
- Re: Locale / Encoding mismatch
- From: Martijn van Oosterhout
- Re: Locale / Encoding mismatch
- Prev by Date: database 1.2G, pg_dump 73M?!
- Next by Date: Re: Locale / Encoding mismatch
- Previous by thread: database 1.2G, pg_dump 73M?!
- Next by thread: Re: Locale / Encoding mismatch
- Indexes: