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

From: Martin Flahault <martin(at)billjobs(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Collate order on Mac OS X, text with diacritics in UTF-8
Date: 2010-01-12 11:36:41
Message-ID: D9357B3E-8821-44C1-9EA7-4305432C9D4F@billjobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Huda Booley (huda@careerjunction.co.za) 2010-01-12 12:53:24 properties/info on functions
Previous Message Dimitri Fontaine 2010-01-12 11:07:33 Re: replication from multiple "master" servers to a single read-only slave