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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
