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.papai@bsdsupportservice.hu> Sunday 06 February 2011 11:02:25
> Adam PAPAI wrote:
> > Pavel Stehule wrote:
> >> 2011/2/5 Adam PAPAI <adam.papai@bsdsupportservice.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?