UTF-8 and LC_CTYPE locale

Поиск

Список

Период

Сортировка

От	Stefan Hans
Тема	UTF-8 and LC_CTYPE locale
Дата	16 мая 2005 г. 06:52:41
Msg-id	0ffa01c559fc$dabc95b0$bf01a8c0@pc1 обсуждение исходный текст
Список	pgsql-general

Дерево обсуждения

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

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

UTF-8 and LC_CTYPE locale