Creating a database with LC_COLLATE tr_TR.UTF-8

From: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Creating a database with LC_COLLATE tr_TR.UTF-8
Date: 2016-12-30 14:25:03
Message-ID: 01b901d262a8$8352b8b0$89f82a10$@1nar.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2016-12-30 14:52:39 Re: Creating a database with LC_COLLATE tr_TR.UTF-8
Previous Message Ram DBA 2016-12-30 06:54:59 Re: Data replication to PostgreSQL