Hi *,
we are using PostgreSQL for data in different languages like English, German and French.
The encoding and locale parameters on our OS (UTF-8 and en_US.UTF-8) had problems e.g. with german umlaut.
After some tries we found encoding and locale parameters (LATIN1 and de_DE.iso88591) which work fine concerning lc_collate and lc_type.
But our clients would prefer an UTF-8 encoding. We have tried all de_*.UTF-8* encodings but none works ("ERROR: invalid multibyte character for locale HINT: The server's LC_CTYPE locale is probably incompatible with the database encoding.").
There are about 140 UTF-8 locales left to try. There is the parameter client_encoding.
What shall we do?
Any hint is highly appreciated.
thx in advance
Stefan