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