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 3064E53553 for ; Thu, 31 Mar 2005 14:59:29 +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 39537-02 for ; Thu, 31 Mar 2005 13:59:24 +0000 (GMT) Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by svr1.postgresql.org (Postfix) with ESMTP id 097F353551 for ; Thu, 31 Mar 2005 14:59:23 +0100 (BST) Received: from bell.credativ.de (pD95019B4.dip0.t-ipconnect.de [217.80.25.180]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 66B38D7836; Thu, 31 Mar 2005 15:59:34 +0200 (CEST) From: Peter Eisentraut To: Tsirkin Evgeny Subject: Re: locale and character set Date: Thu, 31 Mar 2005 15:59:17 +0200 User-Agent: KMail/1.7.1 Cc: pgsql-admin@postgresql.org References: <424BFFF7.3080507@mail.jct.ac.il> In-Reply-To: <424BFFF7.3080507@mail.jct.ac.il> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200503311559.17801.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/503 X-Sequence-Number: 17001 Am Donnerstag, 31. März 2005 15:49 schrieb Tsirkin Evgeny: > Is there any relation between the locale and character set? Every locale expects a certain character set to be used. You can find that out using $ LC_ALL=foo locale charmap If you want things to function correctly, you have to use a character set that matches the one the locale expects. > 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 , That should work, but of course you have no guarantees that the UTF-8 is valid, so the sorting routines and others may behave erratically if they find an error. -- Peter Eisentraut http://developer.postgresql.org/~petere/