Re: BUG #4848: Encoding is incompatible with template database

On Wed, Jun 10, 2009 at 09:16:40AM +0000, Anders Gunnarsson wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4848
> Logged by: Anders Gunnarsson
> Email address: fsogren(at)passagen(dot)se
> PostgreSQL version: 8.4
> Operating system: Windows XP
> Description: Encoding is incompatible with template database
> Details:
>
> So, now I am a member!
>
> Hey, I had problems with the other versions so you gave me a tip to install
> Postgres 8.4 which worked.
>
> BUT when I tried to create a database it says: "
> 22023: new encoding (SQL_ASCII) is incompatible with the encoding of the
> template database (UTF8)"
>
> I've tried to install postgres with "install new template..." and without
> during installation
>
>
> Do you know this problem and how to solve it?
>

Not sure if this is a bug (i've seen it too) but you can solve it by
using template0:
$ createdb -E UTF8 -T template0 foo

Regards,
Simon