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

Re: Locale / Encoding mismatch

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Naz Gassiep <naz(at)mira(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Locale / Encoding mismatch
Date: 2008-03-30 18:03:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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 MarloweDate: 2008-03-30 18:04:47
Subject: Re: Using tables in other PostGreSQL database
Previous:From: Martijn van OosterhoutDate: 2008-03-30 18:01:58
Subject: Re: Locale / Encoding mismatch

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