Hello Samed, After testing, I see that your sugestion also works. Thank you. From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Samed YILDIRIM Sent: Friday, December 30, 2016 6:01 PM To: Ertan Küçükoğlu <ertan.kucukoglu@xxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: 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.kucukoglu@xxxxxxxxxxx>: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
