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@xxxxxxxxxxxxxxxxxxxx> Sunday 06 February 2011 11:02:25 > Adam PAPAI wrote: > > Pavel Stehule wrote: > >> 2011/2/5 Adam PAPAI <adam.papai@xxxxxxxxxxxxxxxxxxxx>: > >> > >> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
