Re: PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting

You need to create database with LC_COLLATE="hu_HU.utf8", e.g.

CREATE DATABASE tx2 ENCODING='UTF-8' TEMPLATE=template0
LC_COLLATE='pl_PL.utf8';

Kind regards,
Radosław Smogura
http://www.softperience.eu

Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu> Sunday 06 February 2011 11:02:25
> Adam PAPAI wrote:
> > Pavel Stehule wrote:
> >> 2011/2/5 Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu>:
> >>
> >> your system locales is correct? PostgreSQL uses only system libs
> >
> > I've tested it with a fresh 8.4 and 9.0.
> >
> > It's the same.
> >
> > My FreeBSD 8.1 supports hu_HU.UTF-8, but I don't know why it's not
> > working.
>
> I've tested it with 8.4 and 9.0 with locale=hu_HU.ISO8859-2,
> encoding=LATIN2, It's working correctly.
>
> But not with locale=hu_HU.UTF-8, encoding=UTF-8
>
> Is it related to the FreeBSD team or the PostgreSQL team?