On Mon, Mar 31, 2008 at 05:37:26AM +1100, Naz Gassiep wrote:
> I've just installed that locale on my system (Debian Sarge). However I'm
> still getting the error. I only set the locale for that user, could it
> be that the locale needs to be set to UTF8 system wide? Here's the output:
The locale
Short answer is: use en_AU.UTF-8 for your locale. If it doesn't exist
you can create it using /etc/locale.gen (assuming you're running some
kind of linux)
I've just installed that locale on my system (Debian Sarge). However I'm
still getting the error. I only set the locale for that user,
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 t
On Mon, Mar 31, 2008 at 04:32:16AM +1100, Naz Gassiep wrote:
> 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'
I have just attempted to upgrade to 8.3.1 and I now get this error when
trying to create a UTF8 DB:
[EMAIL PROTECTED]:~$ 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 encodin
