X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9436C329E47 for ; Fri, 24 Sep 2004 13:37:33 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39055-09 for ; Fri, 24 Sep 2004 12:37:29 +0000 (GMT) Received: from kerberos.logicdis.gr (mail.logicdis.gr [195.97.95.39]) by svr1.postgresql.org (Postfix) with ESMTP id DD669329D14 for ; Fri, 24 Sep 2004 13:37:30 +0100 (BST) Received: from spartakus.logicdis.gr (192.168.20.12 [192.168.20.12]) by kerberos.logicdis.gr with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id TK4D5KVJ; Fri, 24 Sep 2004 15:37:53 +0200 Received: by SPARTAKUS with Internet Mail Service (5.5.2653.19) id ; Fri, 24 Sep 2004 14:47:12 +0200 Message-ID: <01CE0B69E66BD7118991000347ACE0804053BF@SPARTAKUS> X-Sybari-Trust: 2c7413ae 477d8de1 eb4e2ee0 00001039 From: Manolatos Tilemahos To: pgsql-admin@postgresql.org Subject: How to pass initdb LC_COLLATE & locale parameters when using wind ows? (with or without pginstaller) Date: Fri, 24 Sep 2004 14:47:09 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-7" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/227 X-Sequence-Number: 14930 Dear friends, First pls accept my apologies, because I am a new Postgres user, so my questions could be silly. We need to setup a database using UTF-8 encoding, however, by some way, we have to express our need for right Greek character collation order. I tried the default installation using pginstaller, then I created a db (using pgAdminIII) using UTF-8, but still the collation is wrong (=wrong upper() and "order by") for Greek characters. After some googling, I guess that I need to call initdb with the proper locale. Could you please help me with the below questions? 1. Is there a way to define locale options to the pginstaller? 2. If not, how can I (at least) create a new database with UTF-8 and el_GR locale? I am currently using Postgres 8.0 beta1 on Windows XP Pro, and having Greek locale to my computer. Thank you very much in advance, we really appreciate Postgres' superior performance and features. Greetings from Greece, Tilemahos