Re: UTF-8 collation on Windows?

On 02/19/2014 12:16 PM, Dev Kumkar wrote:
> On Thu, Feb 20, 2014 at 1:41 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     What does it set LC_CTYPE to?
>
>     So what happens if you do?:
>
>     createdb -U postgres -E utf8 -l american_usa.65001 <DBNAME>
>
>
> *createdb: database creation failed: ERROR:  invalid locale name:
> "american_usa.65001" *
>
>
>     or
>
>     createdb -U postgres -E utf8 --lc-ctype=american_usa
>     --lc-collate=american_usa <DBNAME>
>
> Succeeds but as replied earlier it creates database with LC_COLLATE =
> 'English_United States.1252' which corresponds to Latin1.

Just noticed you are not specifying the template database. Try using
template0:

createdb -U postgres -E utf8 --lc-ctype=american_usa
--lc-collate=american_usa  -T template0 <DBNAME>

>
> Regards...