Thread: question

question

From
luyen dinhvan
Date:

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.



Re: question

From
Scott Marlowe
Date:
On Tue, Nov 3, 2009 at 3:29 AM, luyen dinhvan <luyendv.hut@gmail.com> 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.