Thread: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
From
Glyn Astill
Date:
When trying to specify an encoding to initdb I get:
createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
8.2 Used to let us create any encoding in initdb. I see that it was in the todo to make this change, but how do I
createmy database in LATIN encoding now?
Do I just change these lines in postgresql.conf:
lc_messages = 'en_GB.UTF-8' # locale for system error message
# strings
lc_monetary = 'en_GB.UTF-8' # locale for monetary formatting
lc_numeric = 'en_GB.UTF-8' # locale for number formatting
lc_time = 'en_GB.UTF-8' # locale for time formatting
Or do I have to do something else? The comments in the .conf file indicate that it's something else I need to
change....
___________________________________________________________
Yahoo! For Good helps you make a difference
http://uk.promotions.yahoo.com/forgood/
Re: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
From
Glyn Astill
Date:
This is sorted now chaps, I was missing a system locale. ta Glyn ----- Original Message ---- > From: Glyn Astill <glynastill@yahoo.co.uk> > To: pgsql-general@postgresql.org > Sent: Friday, 11 April, 2008 2:59:56 PM > Subject: [GENERAL] createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8 > > When trying to specify an encoding to initdb I get: > > createdb: database creation failed: ERROR: encoding LATIN1 does not match > server's locale en_GB.UTF-8 > > 8.2 Used to let us create any encoding in initdb. I see that it was in the todo > to make this change, but how do I create my database in LATIN encoding now? > > Do I just change these lines in postgresql.conf: > > lc_messages = 'en_GB.UTF-8' # locale for system error > message > # strings > lc_monetary = 'en_GB.UTF-8' # locale for monetary formatting > lc_numeric = 'en_GB.UTF-8' # locale for number formatting > lc_time = 'en_GB.UTF-8' # locale for time formatting > > > Or do I have to do something else? The comments in the .conf file indicate that > it's something else I need to change.... > > > > > > > ___________________________________________________________ > Yahoo! For Good helps you make a difference > > http://uk.promotions.yahoo.com/forgood/ > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > ___________________________________________________________ Yahoo! For Good helps you make a difference http://uk.promotions.yahoo.com/forgood/