X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 36D7D9DC892 for ; Mon, 27 Mar 2006 04:57:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08273-01 for ; Mon, 27 Mar 2006 04:57:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from imap.unet.univie.ac.at (imap.unet.univie.ac.at [131.130.221.38]) by postgresql.org (Postfix) with ESMTP id 1DDA09DC840 for ; Mon, 27 Mar 2006 04:56:58 -0400 (AST) X-Spam-Flags: <.FIVETEN-SPAMSRC.BLARS-SPAMSENDER.@imap.unet.univie.ac.at>[80.109.13.165:chello080109013165.10.14.univie.teleweb.at] Received: from [192.168.2.100] (chello080109013165.10.14.univie.teleweb.at [80.109.13.165]) by imap.unet.univie.ac.at (8.12.10/8.12.10) with ESMTP id k2R8um6P058662; Mon, 27 Mar 2006 10:56:52 +0200 Message-ID: <4427A8CF.5070605@falter.at> Date: Mon, 27 Mar 2006 10:56:47 +0200 From: Erwin Brandstetter User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org CC: tgl@sss.pgh.pa.us Subject: Re: database locale and system locale References: <442624FF.6000604@falter.at> <200603261024.00755.peter_e@gmx.net> <44265C08.8040301@falter.at> <26548.1143390039@sss.pgh.pa.us> In-Reply-To: <26548.1143390039@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-DCC-ZID-Univie-Metrics: mx8 4248; Body=0 Fuz1=0 Fuz2=0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/285 X-Sequence-Number: 21042 tgl@sss.pgh.pa.us wrote: > Erwin Brandstetter writes: > >> Wait .. not that great! The system locale is more or less ignored, but >> my sort order will approach randomness? >> > > Peter's point is that a given locale setting will expect a particular > encoding, and if you try to use a different encoding then your sort > ordering will be wrong. Not "random" exactly, but not what you want. Sorry, maybe I am slow in the head. Are you referring to the system locale of the client OS? My question was aiming at the database server OS. (Maybe I have not been clear enough myself.) Example: ~~~~~~~ Postgresql --encoding=UTF8 --locale='de_AT.UTF-8@euro' Server OS: (Debian Sarge) set system locale 'C' (locale 'de_AT.UTF-8@euro' is installed, too) PHP5, Apache. Client: Browser (Mozilla Firefox in our case) on various OSīs (Mac, Win, Linux), set to work with UNICODE data. Would the system locale of the _server_ OS mess with the sort order? (Or with anything at all?) Any sorting done on the client would be based on the _client_ OS system locale, but that is a different question .. Regards Erwin Brandstetter