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

Adam PAPAI <adam.papai@bsdsupportservice.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@mason.cse.buffalo.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