From: | Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr> |
---|---|
To: | "'Samed YILDIRIM'" <samed(at)reddoc(dot)net>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Creating a database with LC_COLLATE tr_TR.UTF-8 |
Date: | 2016-12-30 15:13:47 |
Message-ID: | 01bb01d262af$51b4adc0$f51e0940$@1nar.com.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello Samed,
After testing, I see that your sugestion also works.
Thank you.
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Samed YILDIRIM
Sent: Friday, December 30, 2016 6:01 PM
To: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Creating a database with LC_COLLATE tr_TR.UTF-8
Hi Ertan,
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.1254' LC_CTYPE = 'Turkish_Turkey.1254' TEMPLATE template0;
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
Best regards.
Samed YILDIRIM
30.12.2016, 16:26, "Ertan Küçükoğlu" <mailto:ertan(dot)kucukoglu(at)1nar(dot)com(dot)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=# 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 (mailto:pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | Vikash Pandey | 2017-01-02 07:55:46 | Issue related to audit trigger after upgrade to Postgresql9.6 |
Previous Message | Ertan Küçükoğlu | 2016-12-30 15:06:05 | Re: Creating a database with LC_COLLATE tr_TR.UTF-8 |