UTF-8 and LC_CTYPE locale

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