<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.6/static/multibyte.html</a></div><div> </div><div>Best regards.</div><div>Samed YILDIRIM</div><div> </div><div>30.12.2016, 16:26, "Ertan Küçükoğlu" <ertan(dot)kucukoglu(at)1nar(dot)com(dot)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(at)postgresql(dot)org">pgsql-admin(at)postgresql(dot)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-admin</a></span></blockquote>