On Thu, Feb 20, 2014 at 1:41 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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.
Regards...