On 02/19/2014 12:03 PM, Dev Kumkar wrote:
On Thu, Feb 20, 2014 at 1:19 AM, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general