From: Samed YILDIRIM <samed@reddoc.net>
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Creating a database with LC_COLLATE tr_TR.UTF-8
Date: Fri, 30 Dec 2016 17:00:30 +0200
Message-ID: <3388211483110030@web20o.yandex.ru> (raw)
In-Reply-To: <01b901d262a8$8352b8b0$89f82a10$@1nar.com.tr>
References: <01b901d262a8$8352b8b0$89f82a10$@1nar.com.tr>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<div>Hi Ertan,</div><div> </div><div>Locale names are different on Windows and Linux. Please try using following command to create new database.</div><div>CREATE DATABASE collationtest ENCODING 'UTF8' LC_COLLATE 'Turkish_Turkey.1254' LC_CTYPE = 'Turkish_Turkey.1254' TEMPLATE template0;</div><div> </div><div>Note on document:</div><div>On Windows, however, UTF-8 encoding can be used with any locale.</div><div><em>Ref:</em> <a href="https://www.postgresql.org/docs/9.6/static/multibyte.html">https://www.postgresql.org/docs/9.... regards.</div><div>Samed YILDIRIM</div><div> </div><div>30.12.2016, 16:26, "Ertan Küçükoğlu" <ertan.kucukoglu@1nar.com.tr>:</div><blockquote type="cite"><p>Hello,<br /><br />I am quite new to the community and PostgreSQL. My search in the acrhieves<br />did not show any hints.<br /><br />I just installed PostgreSQL 9.6.1 64bit on Windows 10 64bit OS. Used<br />EnterpriseDB setup.<br /><br />I wanted to create a database using LC_COLLATE "tr_TR.UTF-8". My pgsql<br />command and error I receive is as follows:<br /><br />postgres=# CREATE DATABASE collationtest ENCODING 'UTF-8' LC_COLLATE<br />'tr_TR.UTF-8' TEMPLATE template0;<br />ERROR: invalid locale name: "tr_TR.UTF-8"<br />postgres=#<br /><br />Just for a test, I tried 'tr_TR.UTF8', 'tr_TR' and got same result for all.<br />I am open to any advises and appreciate any help.<br /><br />Thanks & regards,<br />Ertan Küçükoğlu<br /><br /><br /><br /><br /><br /><br /> </p><span>--<br />Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)<br />To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgresql.org/mailpref/pgsql-admi...;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: samed@reddoc.net, ertan.kucukoglu@1nar.com.tr
Subject: Re: Creating a database with LC_COLLATE tr_TR.UTF-8
In-Reply-To: <3388211483110030@web20o.yandex.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox