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: fsog...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
