X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4B02E53379 for ; Sat, 7 May 2005 17:54:24 -0300 (ADT) 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 83178-09 for ; Sat, 7 May 2005 20:54:20 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 097BE531C7 for ; Sat, 7 May 2005 17:54:18 -0300 (ADT) Received: (qmail invoked by alias); 07 May 2005 20:54:20 -0000 Received: from dsl-082-083-250-143.arcor-ip.net (EHLO colt.pezone.net) [82.83.250.143] by mail.gmx.net (mp030) with SMTP; 07 May 2005 22:54:20 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: aarni@kymi.com Subject: Re: encoding Date: Sat, 7 May 2005 22:54:18 +0200 User-Agent: KMail/1.7.2 Cc: "Joel Fradkin" , pgsql-sql@postgresql.org References: <000001c55242$82e0fff0$797ba8c0@jfradkin> <200505071932.35212.aarni@kymi.com> In-Reply-To: <200505071932.35212.aarni@kymi.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200505072254.19214.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.012 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/79 X-Sequence-Number: 21392 Aarni Ruuhimäki wrote: > You might also want (re?)configure your Pg-system with > --enable-locale and set your preferred locale and db default encoding > in initdb to suit your needs, in order to have alphabetical sortings > etc. work ok. If you're still using a PostgreSQL version that has the --enable-locale option then you rather need to upgrade. -- Peter Eisentraut http://developer.postgresql.org/~petere/