Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DE7BA64FD36 for ; Wed, 3 Sep 2008 07:27:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92234-04 for ; Wed, 3 Sep 2008 07:27:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id B941C64FCDE for ; Wed, 3 Sep 2008 07:27:04 -0300 (ADT) Received: (qmail 19690 invoked by uid 0); 3 Sep 2008 10:27:01 -0000 Received: from 192.124.237.8 by www091.gmx.net with HTTP; Wed, 03 Sep 2008 12:27:01 +0200 (CEST) Content-Type: text/plain; charset="iso-8859-1" Date: Wed, 03 Sep 2008 12:27:01 +0200 From: "Jan-Peter Seifert" Message-ID: <20080903102701.205580@gmx.net> MIME-Version: 1.0 Subject: server/db encoding (mix) issues To: Postgres X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX18BgH58mIQBcCroNUsLNaZoJd+AsYwAc6YErJsOuL YsfuUtwph0iJuSIwaTFszYq0OjiGDsW2LCOA== Content-Transfer-Encoding: 8bit X-GMX-UID: R1+NcHtkMmA6QUr6ZWFn25s5MjQ1N52R 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: 200809/4 X-Sequence-Number: 30097 Hello, we have a mix of older software still using LATIN1 as db encoding and the psqlODBC-drivers (ANSI) and newer software using UTF8 as db encoding. As running two server instances would use up more resources(?) than just one we'd like to have all dbs in one cluster. Which cons against this solution are there? Which operating system locale should be used then? C locale is recommended in the docs - also because of better performance. However, the language of the software is not English but German - so shouldn't there be problems with sorting German Umlauts etc. correctly etc.? Which encoding should the server have - UTF8/Unicode or LATIN1? BTW which is the correct locale for LATIN1 and German (de_DE (my guess) or de_DE@euro (which seems to be for LATIN9)). Using SQL_ASCII doesn't seem to be a wise choice. Are there no problems when connecting with psqlODBC-ANSI drivers if the server encoding is UTF8/Unicode? I'd be happy if you could enlighten me a bit. Thank you very much, Peter -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer