Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 913B82E006C for ; Wed, 19 Mar 2008 08:02:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 54912-05 for ; Wed, 19 Mar 2008 08:02:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id DE1152E0103 for ; Wed, 19 Mar 2008 08:02:09 -0300 (ADT) Received: (qmail 6080 invoked by uid 0); 19 Mar 2008 11:02:02 -0000 Received: from 192.124.237.8 by www171.gmx.net with HTTP; Wed, 19 Mar 2008 12:02:02 +0100 (CET) Content-Type: text/plain; charset="iso-8859-1" Date: Wed, 19 Mar 2008 12:02:03 +0100 From: Jan-Peter.Seifert@gmx.de Message-ID: <20080319110203.98050@gmx.net> MIME-Version: 1.0 Subject: LATIN1 with German Locale on Windows To: pgsql-admin@postgresql.org X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX19GtDJjEZJGKFg8hTecD4/U+hnawOpa17t74skjiU Y3boG1n/msZio3nYUmEqvRbQWDVzKPeI5Elw== Content-Transfer-Encoding: 8bit X-GMX-UID: nMTTcy9uTXsuTlLyb2Q5bntCRzdyMsNF X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/140 X-Sequence-Number: 28623 Hi there, sorry if this is the wrong group. The problem is that the software in use is not capable of using UTF-8 as encoding yet. So LATIN1 has been used as server and database encoding for Linux and Windows. However, as PostgreSQL 8.3 is enforcing matching encodings and locales it's not possible to use LATIN1 with a German locale anymore. The accepted C-locale is not sufficient as it lacks correct sorting of Umlauts etc. . Will this be fixed or is there a way to intialize a cluster with LATIN and German locale? Thank you very much in advance, Peter -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger