This was help me, on Debian Sarge.
PostgreSQL problems with collation sequence!
#dpkg-reconfigure locales - generate - "hu_HU" and NLS hu_UTF8
#reboot
#/etc/init.d/postgresql stop
#su postgres -> postgres@srv02:
empty directory /var/lib/postgres/data
/usr/lib/postgresql/bin/initdb -U
postgres --locale=hu_HU --lc-collate=hu_HU -E LATIN2 \
-D /var/lib/postgres/data -W --pwprompt
... set same password for "postgres" root
cd /var/lib/postgres/data
rm pg_hba.conf
rm pg_ident.conf
rm postgresql.conf
ln -s /etc/postgresql/pg_hba.conf pg_hba.conf
ln -s /etc/postgresql/pg_ident.conf pg_ident.conf
ln -s /etc/postgresql/postgresql.conf postgresql.conf
recreate users and databases - pg_dump?
----- Original Message -----
From: "Havasvölgyi Ottó" <h.otto@freemail.hu>
To: <pgsql-novice@postgresql.org>
Sent: Sunday, May 01, 2005 8:33 PM
Subject: [NOVICE] how to make collation work
> Hi all,
>
> I am a beginner in Linux and Postgres too, so take this into
> consideration.
> I have installed Fedora Core 3, and PostgreSQL 8.0.2 from source on it.
> All right so far. Now I would like to have a Hungarian collation in my
> tables. This is what I have tried so far:
> I checked what Hungarian locales my Linux supports. These are: hu_HU,
> hu_HU.iso88592, hu_HU.utf8, and hungarian. So far I have tried the first
> and the second with initdb, set the --locale, --lc-collate and --lc-ctype
> to that locale. But after filling a table with Hunagrian characters, and
> selecting it all with order by didn't give the result I expected. The
> encoding of the database and the client was both LATIN2. Neither worked
> the upper() and lower() functions correct with Hungarian characters.
>
> What did I do wrong? Please help.
>
> Thanks,
> Otto
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
