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

MailingLists <mailinglist@xxxxxxx> · Mon, 13 Sep 2010 11:48:50 +0000



    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