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 7FCCD5280D for ; Fri, 24 Jun 2005 11:56:10 -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 64007-06 for ; Fri, 24 Jun 2005 14:56:01 +0000 (GMT) Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by svr1.postgresql.org (Postfix) with ESMTP id 103FB528C7 for ; Fri, 24 Jun 2005 11:56:00 -0300 (ADT) Received: from [192.168.1.221] (unknown [195.20.225.146]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 52B00D7656; Fri, 24 Jun 2005 16:58:28 +0200 (CEST) From: Peter Eisentraut To: Hannes Dorbath Subject: Re: unicode Date: Fri, 24 Jun 2005 16:55:56 +0200 User-Agent: KMail/1.8.1 Cc: pgsql-admin@postgresql.org References: <42bbcec1$0$5607$8fe63b2a@news.disputo.net> In-Reply-To: <42bbcec1$0$5607$8fe63b2a@news.disputo.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200506241655.56840.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/198 X-Sequence-Number: 17953 Am Freitag, 24. Juni 2005 11:47 schrieb Hannes Dorbath: > can someone summarize the steps necessary to get PG8 fully setup for > UTF-8 use, please? Locale, initDB params? Especially that SQL functions > like UPPER, LOWER, LENGTH etc work correct as well.. Use initdb --locale=de_DE.utf8 and that should be all.