Postgres - creating english states .1252 sort

Question

Postgres 9.2 on Windows 7, I am trying to create an English_United States.1252 user mapping :

user=# create database test template template0 ENCODING = 'utf8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252';
CREATE DATABASE
user=# \c test
test=# create collation english from "English_United States.1252";
ERROR:  collation "English_United States.1252" for encoding "UTF8" does not exist

And as you can see, the following error is displayed: ERROR: mapping "English_United States.1252" for encoding "UTF8" does not exist

What is the correct way to create US English sorting for Windows for utf8 db encoding?

Answer 1

CREATE COLLATION "English_United States.1252" (
    LC_COLLATE='English_United States.1252',
    LC_CTYPE='English_United States.1252');