how to make collation work

From: Havasvölgyi Ottó <h(dot)otto(at)freemail(dot)hu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: how to make collation work
Date: 2005-05-01 18:33:02
Message-ID: 00f901c54e7c$353b7f10$c700a8c0@OTTO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message tövis 2005-05-01 19:22:41 Re: how to make collation work
Previous Message Tom Lane 2005-05-01 17:24:29 Re: psql: Is it possible to run a query from a *sql file?