Skip site navigation (1) Skip section navigation (2)

Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD
Date: 2011-02-06 16:06:10
Message-ID: 6870.1297008370@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu> writes:
> [ hu_HU.UTF-8 locale doesn't sort as expected on ]
> FreeBSD titanium 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49
> UTC 2010     root(at)mason(dot)cse(dot)buffalo(dot)edu:/usr/obj/usr/src/sys/GENERIC  amd64

Do you get the expected sort ordering from the "sort" command either?
I'm betting not.  This is not something Postgres controls -- we just
rely on the results of strcoll().

I don't know the state of affairs on FreeBSD for sure, but I do know
that the UTF-8 locales are fairly broken on Mac OS X, which is a BSD
derived platform too.  It looks like nobody in BSD-land has bothered to
put in the work to make multibyte characters sort properly.

You might have better luck with hu_HU using a suitable LATINn character
set instead of UTF8.  If that still doesn't do what you want, you might
have no choice but to move off BSD :-(

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Adam PAPAIDate: 2011-02-06 16:38:59
Subject: Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD
Previous:From: Adam PAPAIDate: 2011-02-06 10:30:10
Subject: Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group