From: Peter Eisentraut <peter_e@gmx.net>
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: Postgres <pgsql-admin@postgresql.org>
Subject: Re: server/db encoding (mix) issues
Date: Thu, 04 Sep 2008 16:46:33 +0300
Message-ID: <48BFE6B9.7030103@gmx.net> (raw)
In-Reply-To: <20080903102701.205580@gmx.net>
References: <20080903102701.205580@gmx.net>
Jan-Peter Seifert wrote:
> 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.
Set your locale to de_DE.utf8 and use UTF8 as server encoding.
I would be interested to know where the documentation "recommends" using
the C locale. That would certainly not be reasonable for many uses.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter_e@gmx.net, Jan-Peter.Seifert@gmx.de
Subject: Re: server/db encoding (mix) issues
In-Reply-To: <48BFE6B9.7030103@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox