On 02/19/2014 12:03 PM, Dev Kumkar wrote:
On Thu, Feb 20, 2014 at 1:19 AM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.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...



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to