Re: server/db encoding (mix) issues

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: server/db encoding (mix) issues
Дата
Msg-id 48BFE6B9.7030103@gmx.net
обсуждение исходный текст
Ответ на server/db encoding (mix) issues  ("Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>)
Ответы Re: server/db encoding (mix) issues  (Jan-Peter.Seifert@gmx.de)
Список pgsql-admin
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
usingUTF8 as db encoding. As running two server instances would use up more resources(?) than just one we'd like to
haveall 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
notEnglish but German - so shouldn't there be problems with sorting German Umlauts etc. correctly etc.? Which encoding
shouldthe server have - UTF8/Unicode or LATIN1? BTW which is the correct locale for LATIN1 and German (de_DE (my guess)
orde_DE@euro (which seems to be for LATIN9)). Using SQL_ASCII doesn't seem to be a wise choice. Are there no problems
whenconnecting with psqlODBC-ANSI drivers if the server encoding is UTF8/Unicode? I'd be happy if you could enlighten
mea 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.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_dump etc. versions
Следующее
От: Ben Kim
Дата:
Сообщение: Re: Database Conversion