Search Postgresql Archives

Re: Locale / Encoding mismatch

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



PG 8.3 has strict rule what CTYPE and LOCALLE is allowed. It is protection before possible problems with data processing. You probably need set en_AU.uft8 locale when you initialize server.

		Zdenek


Naz Gassiep napsal(a):
I have just attempted to upgrade to 8.3.1 and I now get this error when trying to create a UTF8 DB:

postgres@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?



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux