Collate order on Mac OS X, text with diacritics in UTF-8

Поиск
Список
Период
Сортировка
От Martin Flahault
Тема Collate order on Mac OS X, text with diacritics in UTF-8
Дата
Msg-id D9357B3E-8821-44C1-9EA7-4305432C9D4F@billjobs.com
обсуждение исходный текст
Ответы Re: Collate order on Mac OS X, text with diacritics in UTF-8  (Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>)
Re: Collate order on Mac OS X, text with diacritics in UTF-8  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general
Дерево обсуждения
Hi,

We are a software publisher searching for a new DBMS for our software. We have more than one hundred installed servers, running Mac OS and a Primebase database.

We have spend some time evaluating PostgreSQL and we can't get correct outputs with the ORDER BY command.
LC_COLLATE and LC_CTYPE are set to fr_FR.UTF-8.

It seems there is a known problem with the collating order of text including diacritics with the UTF8 encodings on BSD systems.

Does anyone know a workaround ?

Thanks for your answers,

Martin

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

Предыдущее
От: annahensjerry
Дата:
Сообщение: annahensjerry has invited you to Weebly
Следующее
От: ChronicDB
Дата:
Сообщение: ChronicDB: Live database schema updates with zero downtime