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 D4FCE9DCCFC for ; Sun, 26 Mar 2006 04:24:03 -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 29928-08 for ; Sun, 26 Mar 2006 04:24:04 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 182419DCBB1 for ; Sun, 26 Mar 2006 04:24:00 -0400 (AST) Received: (qmail invoked by alias); 26 Mar 2006 08:24:01 -0000 Received: from dslb-084-063-003-189.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.3.189] by mail.gmx.net (mp037) with SMTP; 26 Mar 2006 10:24:01 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: database locale and system locale Date: Sun, 26 Mar 2006 10:24:00 +0200 User-Agent: KMail/1.8.3 Cc: Erwin Brandstetter References: <442624FF.6000604@falter.at> In-Reply-To: <442624FF.6000604@falter.at> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603261024.00755.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.129 required=5 tests=[AWL=0.129] X-Spam-Score: 0.129 X-Spam-Level: X-Archive-Number: 200603/268 X-Sequence-Number: 21025 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. > 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. > Is it enough to have an UTF8 locale installed on the system? You need to have it installed and you need to tell initdb to use it. > Or does it actually have to be the system locale? No. > Do multiple UTF8 system locales have any effect? No. -- Peter Eisentraut http://developer.postgresql.org/~petere/