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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adam PAPAI | 2011-02-06 16:38:59 | Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD |
Previous Message | Adam PAPAI | 2011-02-06 10:30:10 | Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD |