Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cMy7R-0000PY-Tw for pgsql-admin@arkaria.postgresql.org; Fri, 30 Dec 2016 14:25:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cMy7R-0001Ca-CJ for pgsql-admin@arkaria.postgresql.org; Fri, 30 Dec 2016 14:25:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cMy7Q-0001CG-IP for pgsql-admin@postgresql.org; Fri, 30 Dec 2016 14:25:16 +0000 Received: from mta09.1.doruk.net.tr ([212.58.5.120] helo=mta09.doruk.net.tr) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cMy7J-0008I6-J3 for pgsql-admin@postgresql.org; Fri, 30 Dec 2016 14:25:15 +0000 Received: from cmail19.webkontrol.doruk.net.tr ([212.58.6.99]) by mta09.doruk.net.tr with esmtp (Exim 4.86) (envelope-from ) id 1cMy7V-000ArW-56 for pgsql-admin@postgresql.org; Fri, 30 Dec 2016 17:25:21 +0300 Received: from DESKTOPM80CG12 ([212.252.163.146]) by cmail19.webkontrol.doruk.net.tr (IceWarp 11.1.2.0) with ASMTP id 201612301726421067 for ; Fri, 30 Dec 2016 17:26:42 +0300 From: =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= To: 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> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-9" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AdJiqD67nvqi1hbASa+AJHe4J9P0oA== Content-Language: tr X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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=FC=E7=FCko=F0lu --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin