On 02/19/2014 12:03 PM, Dev Kumkar wrote:
> On Thu, Feb 20, 2014 at 1:19 AM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> So what is the exact command you are using?
>
>
> createdb -U postgres -E utf8 -l american_usa <DBNAME>
> Above command fails to create utf-8 LC_COLLATE.
What does it set LC_CTYPE to?
So what happens if you do?:
createdb -U postgres -E utf8 -l american_usa.65001 <DBNAME>
or
createdb -U postgres -E utf8 --lc-ctype=american_usa
--lc-collate=american_usa <DBNAME>
>
> Regards...