Comment 34 for bug 573318

hegemon8 (pantokrata2) wrote :

I've fixed this issue for my case. I have kubuntu 12.04 (64-bit) and tried to install airtime. And it was failing. As I'm newbie I've spent few hours searching for a cause. in log file i found this:

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.

Next two hours looking for a right solution (of many I've found), and thanks to this:

http://askubuntu.com/questions/20880/how-do-i-create-a-unicode-databases-in-postgresql-8-4
Ive entered in terminal:
sudo pg_dropcluster --stop 9.1 main
sudo pg_createcluster --locale=en_US.utf8 --start 9.1 main

And works fine 4 me :)