Postgres Pro
Downloads
Home   >   mailing lists

Collate order on Mac OS X, text with diacritics in UTF-8 - Mailing list pgsql-general

From Martin Flahault
Subject Collate order on Mac OS X, text with diacritics in UTF-8
Date
Msg-id D9357B3E-8821-44C1-9EA7-4305432C9D4F@billjobs.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: annahensjerry
Date:
Subject: annahensjerry has invited you to Weebly
Next
From: ChronicDB
Date:
Subject: ChronicDB: Live database schema updates with zero downtime