Hi Patrick,I doubt that you need a server set to any locale which isn't UTF8. UTF8 is universal and can handle all characters.
A client can (and does) specify the locale it wants to use for communication with the server. So it's no problem at all if clients use cp1252 while the server is capable of storing also characters beyond this 8-bit-encoding.
Hope this helps. Regards, Holger Am 04.03.21 um 09:40 schrieb mail@xxxxxxxxxxxxx:
Hello,at the moment I am running two different PostgreSQL (12) servers on one Ubuntu 20.04 machine.For server one I need WIN1252 encoding with "de_DE.cp1252" locales set.For server two I need UTF8 encoding, but also with "de_DE.cp1252" locales set.I added support for de_DE.CP1252 CP1252 de_DE.CP1252 UTF-8 to /usr/local/share/i18n/SUPPORTED and /etc/locale.gen and ran locale-genPostgreSQL seems only to recognize the last entry I added. So I can either use "WIN1252" or "UTF-8" encoding with "de_DE.cp1252" locales.Maybe I just have problems understanding how Liunx is handling encodings and locales.Does anyone is successfully running PostgreSQL with a similar setup as I described?Kind regards, Patrick
-- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
