From: Peter Eisentraut <peter_e@gmx.net>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Issues with LC_COLLATE, across 8.3/8.4 on various platforms
Date: Wed, 03 Feb 2010 21:16:36 +0200
Message-ID: <1265224596.16965.1.camel@vanquo.pezone.net> (raw)
In-Reply-To: <201002031705.36226.achill@matrix.gatewaynet.com>
References: <201002021426.44936.achill@matrix.gatewaynet.com>
<201002021728.39492.achill@matrix.gatewaynet.com>
<1265208800.10962.13.camel@fsopti579.F-Secure.com>
<201002031705.36226.achill@matrix.gatewaynet.com>
On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote:
> Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
> > On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
> > > It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
> > > are two different stories, hence the seen results.
> >
> > The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken.
> >
> > This is becoming a FAQ ...
>
> This is a libc/locale combination issue. Care to elaborate?
> AFAICT for my case in FreeBSD, the greek UTF locale el_GR.UTF-8 behaves as expected without problems.
Well,
"""
while in all of
PostgreSQL 8.3.3 on i686-pc-linux-gnu (lc_collate=C)
PostgreSQL 8.3.7 (lc_collate=el_GR.UTF-8) on i386-unknown-freebsd6.3
PostgreSQL 8.4.1 on x86_64-unknown-freebsd8.0 (lc_collate=en_US.UTF-8),
gives
fooname
-------------------------
Cylinder Liner No1
Cylinder head No1
Cylinder head cover No1
"""
is not a correct sorting result in my book, unless your measure of
correctness is ASCII byte value order. And then it's left as an
exercise to determine what the results would be for texts involving
non-ASCII letters.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter_e@gmx.net, achill@matrix.gatewaynet.com
Subject: Re: Issues with LC_COLLATE, across 8.3/8.4 on various platforms
In-Reply-To: <1265224596.16965.1.camel@vanquo.pezone.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox