Postgres Pro
Downloads
Home   >   mailing lists

new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) - Mailing list pgsql-general

From MailingLists
Subject new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
Date
Msg-id 4C8E0FA2.7010605@tdeo.fr
Whole thread Raw
Responses Re: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Mikko Partio
Date:
Subject: Re: Incrementally Updated Backups
Next
From: Craig Ringer
Date:
Subject: Re: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)