This is sorted now chaps, I was missing a system locale. ta Glyn ----- Original Message ---- > From: Glyn Astill <glynastill@xxxxxxxxxxx> > To: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > 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/
