The "New Encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)" issue when creating Odoo8 databases

Odoo8 When you create a database, the following error message is displayed:

Dataerror:new encoding (UTF8) is incompatible and the encoding of the template database (SQL_ASCII) HINT: Use the  sam E encoding as in the template database, or use TEMPLATE0 as template.

Workaround:

1. First, we need to drop template1. Templates can ' t is dropped, so we first modify it so T's an ordinary database:

   UPDATE pg_database SET datistemplate = FALSE WHERE datname = ‘template1‘;

2. Now we can drop it:

   DROP DATABASE template1;

3. Now it time to the CREATE database from Template0, with a new default encoding:

   CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = ‘UNICODE‘;

4. Now modify template1 so it ' s actually a template:

   UPDATE pg_database SET datistemplate = TRUE WHERE datname = ‘template1‘;

5. Now switch to Template1 and VACUUM FREEZE the template:

   \c template1

   VACUUM FREEZE;

Problem should be resolved.

The "New Encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)" issue when creating Odoo8 databases