On 13/09/10 19:48, MailingLists wrote:
> 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.
You could drop template1 (the default template database) and recreate it
from template0 with a utf-8 encoding.
--
Craig Ringer
Tech-related writing: http://soapyfrogs.blogspot.com/