Unix Technical Forum

createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8

This is a discussion on createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8 within the Pgsql General forums, part of the PostgreSQL category; --> When trying to specify an encoding to initdb I get: createdb: database creation failed: ERROR: encoding LATIN1 does not ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-12-2008, 02:05 AM
Glyn Astill
 
Posts: n/a
Default 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 encodingnow?

Do I just change these lines in postgresql.conf:

lc_messages = 'en_GB.UTF-8' # locale for system errormessage
# 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:01 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com