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

createdb: database creation failed: ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

HINT:  Use the same encoding as in the template database, or use template0 as template.

createdb: database creation failed: ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)HINT:  Use the same encoding as in the template database, or use template0 as template.

createdb my_prod -E UTF8 -T template0

Posted on July 27, 2010 at 12:11 pm by Jordan Carter · Permalink
In: Server Config · Tagged with: ,

One Response

  1. Written by Shevaun Ryan
    on September 9, 2011 at 2:21 pm
    Permalink

    Or you can change template1’s default encoding to be UTF8. Instructions here: http://journal.tianhao.info/2010/12/postgresql-change-default-encoding-of-new-databases-to-utf-8-optional/

Leave a Reply