new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

From: MailingLists <mailinglist(at)tdeo(dot)fr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
Date: 2010-09-13 11:48:50
Message-ID: 4C8E0FA2.7010605@tdeo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all of you,

I'm currently working on a centos that I manage with webmin.
A sI try to create a DB with unicode encoding the following message is
returned to me :

new encoding (UTF8) is incompatible with the encoding of the
template database (SQL_ASCII)

After a little googling, I felt happy because the solution seems easy to
create a new utf8 db :
createdb -E UTF8 -T template0 myDB

Unfortunately, I would like to create a default template database in UTF
or accepting all others encoding.

Your help would be usefull,

Best regards,

Florent THOMAS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-09-13 12:30:38 Re: How to inherit search_path from template
Previous Message Sam Mason 2010-09-13 10:33:55 Re: Post Install / Secure PostgreSQL