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 73F605359C for ; Thu, 31 Mar 2005 15:08:16 +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 40542-07 for ; Thu, 31 Mar 2005 14:08:11 +0000 (GMT) Received: from mail1.cc.huji.ac.il (real-outmail.cc.huji.ac.il [132.64.1.17]) by svr1.postgresql.org (Postfix) with ESMTP id 218155356C for ; Thu, 31 Mar 2005 15:08:10 +0100 (BST) Received: from mail1.cc.huji.ac.il (localhost [127.0.0.1]) by mail1.cc.huji.ac.il (Postfix) with SMTP id 6E9C9163DA6; Thu, 31 Mar 2005 16:08:12 +0200 (IST) Received: by mail1.cc.huji.ac.il (Postfix, from userid 31998) id 625F3163DA8; Thu, 31 Mar 2005 16:08:12 +0200 (IST) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail1.cc.huji.ac.il (Postfix) with ESMTP id E6BA2163DA6; Thu, 31 Mar 2005 16:08:11 +0200 (IST) Message-ID: <424C0554.7050306@mail.jct.ac.il> Date: Thu, 31 Mar 2005 16:12:36 +0200 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Peter Eisentraut Cc: Tsirkin Evgeny , pgsql-admin@postgresql.org Subject: Re: locale and character set References: <424BFFF7.3080507@mail.jct.ac.il> <200503311559.17801.peter_e@gmx.net> In-Reply-To: <200503311559.17801.peter_e@gmx.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable 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/505 X-Sequence-Number: 17003 Peter Eisentraut wrote: >Am Donnerstag, 31. M=E4rz 2005 15:49 schrieb Tsirkin Evgeny: > =20 > >>Is there any relation between the locale and character set? >> =20 >> > >Every locale expects a certain character set to be used. You can find t= hat=20 >out using > >$ LC_ALL=3Dfoo locale charmap > >If you want things to function correctly, you have to use a character se= t that=20 >matches the one the locale expects. > > =20 > Of course i understand that i was just interested in cases were no=20 particular charset is inforced like SQL_ASCII but i still want the sorting and searching to work. The question is also in such case what the server will do if it finds a=20 character that is not utf-8 ? I understand from manual that it just show it's hex value ,is that right? >>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 , >> =20 >> > >That should work, but of course you have no guarantees that the UTF-8 is= =20 >valid, so the sorting routines and others may behave erratically if they= find=20 >an error. > > =20 > The question is how it will behave will this eraise an error or it will=20 just not sork correctly?