title: Postgres - creating English_United States.1252 collation
body: <p>Postgres 9.2 on Windows 7, I'm trying to <strong>create English_United States.1252 custom collation</strong>:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>And as you see, the following error is displayed:
  <strong>ERROR:  collation "English_United States.1252" for encoding "UTF8" does not exist</strong></p>
  
  <p>What's the proper way to create English United States collation on Windows for utf8 db encoding?</p>