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 01BCF9DCD13 for ; Sun, 26 Mar 2006 05:17:07 -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 43549-01 for ; Sun, 26 Mar 2006 05:17:09 -0400 (AST) X-Greylist: delayed 03:54:37.862243 by SQLgrey- Received: from imap.unet.univie.ac.at (unet-lmtp.univie.ac.at [131.130.221.38]) by postgresql.org (Postfix) with ESMTP id A99449DCCFC for ; Sun, 26 Mar 2006 05:17:05 -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 k2Q9GuHK170454; Sun, 26 Mar 2006 11:16:58 +0200 Message-ID: <44265C08.8040301@falter.at> Date: Sun, 26 Mar 2006 11:16:56 +0200 From: Erwin Brandstetter User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org CC: peter_e@gmx.net Subject: Re: database locale and system locale References: <442624FF.6000604@falter.at> <200603261024.00755.peter_e@gmx.net> In-Reply-To: <200603261024.00755.peter_e@gmx.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-DCC-ZID-Univie-Metrics: mx9.univie.ac.at 4249; 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/269 X-Sequence-Number: 21026 peter_e@gmx.net wrote: > Erwin Brandstetter wrote: > >> I've been reading tons of stuff on locale and postgresql. I am still >> not in the clear about some details, though: how do system locale and >> database locale work together (or not)? >> > > The system locale is more or less ignored. What matters are the locales > set in the database. > Great! > >> If I am running a database cluster with --encoding= UTF8, are there >> any troubles to be expected if the system locale remains "C" or >> somehting like "de_AT.iso885915@euro"? >> > > Your sort order will approach randomness. > (...) Wait .. not that great! The system locale is more or less ignored, but my sort order will approach randomness? Can you or anyone shed some more light on this? I am even more confused than I was before .. Regards Erwin Brandstetter