For those who tried to setup Odoo (ex openERP) with a postgreSQL database, we might face a problem when running using the web setup for the first time.
The error I got was
DataError: 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.
Fixing this isn’t that hard but you need access to the database server to make some fixes to the template0 or template1 schema (see link mentioned below).
I don’t see the point to copy / paste other blog content, just follow the instructions mentioned in the link below and you’re done.
PostgreSQL documentation: Template Databases