From: Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
To: pgsql-admin@postgresql.org
Subject: Creating a database with LC_COLLATE tr_TR.UTF-8
Date: Fri, 30 Dec 2016 17:25:03 +0300
Message-ID: <01b901d262a8$8352b8b0$89f82a10$@1nar.com.tr> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello,
I am quite new to the community and PostgreSQL. My search in the acrhieves
did not show any hints.
I just installed PostgreSQL 9.6.1 64bit on Windows 10 64bit OS. Used
EnterpriseDB setup.
I wanted to create a database using LC_COLLATE "tr_TR.UTF-8". My pgsql
command and error I receive is as follows:
postgres=# CREATE DATABASE collationtest ENCODING 'UTF-8' LC_COLLATE
'tr_TR.UTF-8' TEMPLATE template0;
ERROR: invalid locale name: "tr_TR.UTF-8"
postgres=#
Just for a test, I tried 'tr_TR.UTF8', 'tr_TR' and got same result for all.
I am open to any advises and appreciate any help.
Thanks & regards,
Ertan Küçükoðlu
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: ertan.kucukoglu@1nar.com.tr
Subject: Re: Creating a database with LC_COLLATE tr_TR.UTF-8
In-Reply-To: <01b901d262a8$8352b8b0$89f82a10$@1nar.com.tr>
* 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