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 40FF45355F for ; Thu, 31 Mar 2005 14:45:28 +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 34683-04 for ; Thu, 31 Mar 2005 13:45:22 +0000 (GMT) Received: from mail3.cc.huji.ac.il (real-outmail.cc.huji.ac.il [132.64.1.21]) by svr1.postgresql.org (Postfix) with ESMTP id 897D253550 for ; Thu, 31 Mar 2005 14:45:19 +0100 (BST) Received: from mail3.cc.huji.ac.il (localhost [127.0.0.1]) by mail3.cc.huji.ac.il (Postfix) with SMTP id B95504089D; Thu, 31 Mar 2005 15:45:19 +0200 (IST) Received: by mail3.cc.huji.ac.il (Postfix, from userid 31998) id AD327408BE; Thu, 31 Mar 2005 15:45:19 +0200 (IST) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail3.cc.huji.ac.il (Postfix) with ESMTP id 39C424089D for ; Thu, 31 Mar 2005 15:45:19 +0200 (IST) Message-ID: <424BFFF7.3080507@mail.jct.ac.il> Date: Thu, 31 Mar 2005 15:49:43 +0200 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: locale and character set Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.658 from Wed Mar 30 18:32:40 2005 CET X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/502 X-Sequence-Number: 17000 Hi list! Is there any relation between the locale and character set? For example if i store the data as sql_ascii can i still use the locale as utf-8? In my case i have the data stored as ascii but i just know it is actually utf-8 and i am doing upgrade , So i would like to leave the ascii as internal format in case there are any non legal chars in db but allow text search on non english characters . Note that i don't want any server - client data conversion,i just want the server assume that it is dealing with utf-8. Thanks. Evgeny.