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.
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(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?
In response to
pgsql-general by date
|Next:||From: Scott Marlowe||Date: 2008-03-30 18:04:47|
|Subject: Re: Using tables in other PostGreSQL database|
|Previous:||From: Martijn van Oosterhout||Date: 2008-03-30 18:01:58|
|Subject: Re: Locale / Encoding mismatch|