On Tue, Nov 3, 2009 at 3:29 AM, luyen dinhvan <luyendv.hut@xxxxxxxxx> wrote: > > createdb: database creation failed: ERROR: encoding LATIN1 does not match > server's locale en_US.utf8 > DETAIL: The server's LC_CTYPE setting requires encoding UTF8. PG version? OS? Command used to attempt creation? In later versions you sometimes have to use the template0 database to get some encodings to work. And some encodings just aren't possible with certain locales. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general