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

BUG #4848: Encoding is incompatible with template database

From
"Anders Gunnarsson"
Date:
The following bug has been logged online:

Bug reference:      4848
Logged by:          Anders Gunnarsson
Email address:      fsogren@passagen.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?

Ty Dave!

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

From
Simon Bertrang
Date:
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@passagen.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