1
Vote

Error 22023

description

While going through the Test database setup, I get this error.
 
Error: 22023: new collation (English_United States.1252) is incompatible with the collation of the template database (English)
 
I just did a default install of Postgres.
I had to run a cmd as the postgres user to init the db
"initdb -D "c:\Program Files\PostgreSQL\8.4\data" -E UTF8 --locale=English"
 
From what I can see, the locale is correct?
How do I go about resolving this?

comments

idgara wrote Feb 9, 2010 at 6:37 AM

fixed
"initdb -D "c:\Program Files\PostgreSQL\8.4\data" -E UTF8 --locale="English_United States.1252"

wrote Feb 14, 2013 at 1:41 AM