From: =?utf-8?B?RXJ0YW4gS8O8w6fDvGtvxJ9sdQ==?= <ertan.kucukoglu@1nar.com.tr>
To: "'Samed YILDIRIM'" <samed@reddoc.net>,
	<pgsql-admin@postgresql.org>
References: <01b901d262a8$8352b8b0$89f82a10$@1nar.com.tr>
 <3388211483110030@web20o.yandex.ru>
In-Reply-To: <3388211483110030@web20o.yandex.ru>
Subject: Re: Creating a database with LC_COLLATE tr_TR.UTF-8
Date: Fri, 30 Dec 2016 18:13:47 +0300
Message-ID: <01bb01d262af$51b4adc0$f51e0940$@1nar.com.tr>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQEbGImbBUBK4P5KKHDwqq5qgZW4ggHoJo05on/qRTA=
Content-Language: tr
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hello Samed,

After testing, I see that your sugestion also works.

Thank you.=20


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
.org] On Behalf Of Samed YILDIRIM
Sent: Friday, December 30, 2016 6:01 PM
To: Ertan K=C3=BC=C3=A7=C3=BCko=C4=9Flu <ertan.kucukoglu@1nar.com.tr>; pgsq=
l-admin@postgresql.org
Subject: Re: [ADMIN] Creating a database with LC_COLLATE tr_TR.UTF-8

Hi Ertan,
=20
Locale names are different on Windows and Linux. Please try using following=
 command to create new database.
CREATE DATABASE collationtest ENCODING 'UTF8' LC_COLLATE 'Turkish_Turkey.12=
54' LC_CTYPE =3D 'Turkish_Turkey.1254' TEMPLATE template0;
=20
Note on document:
On Windows, however, UTF-8 encoding can be used with any locale.
Ref: https://www.postgresql.org/docs/9.6/static/multibyte.html
=20
Best regards.
Samed YILDIRIM
=20
30.12.2016, 16:26, "Ertan K=C3=BC=C3=A7=C3=BCko=C4=9Flu" <mailto:ertan.kucu=
koglu@1nar.com.tr>:
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=3D# CREATE DATABASE collationtest ENCODING 'UTF-8' LC_COLLATE
'tr_TR.UTF-8' TEMPLATE template0;
ERROR: invalid locale name: "tr_TR.UTF-8"
postgres=3D#

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=C3=BC=C3=A7=C3=BCko=C4=9Flu


=20
--
Sent via pgsql-admin mailing list (mailto:pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin