I have a PgSQL node on a FreeBSD 8.1-RELEASE.
(PostgreSQL) 9.0.3 client/server.
pkg_info | grep 'postgresql'
postgresql-client-9.0.3
postgresql-server-9.0.3
I have a lots of UTF8 database with hu_HU.UTF8 COLLATE and LC_CTYPE
For example:
test | pgsql | UTF8 | hu_HU.UTF-8 | hu_HU.UTF-8
The problem is with the "ORDER BY", which does not sort the results
corretly.
Table "public.erdekessegek"
Column | Type | Modifiers
--------+------------------------+-----------
lead | character varying(255) |
test=# select * from erdekessegek order by lead asc;
lead
-------
Adi
Bedi
Evi
Zsolt
Ádi
Évi
(6 rows)
which is not correct.
It should be:
Adi
Ádi
Bedi
Evi
Évi
Zsolt
The "chars" wich accents always at the end of the order by but I don't
know why.
What can I do to make it work? I've read all docs on this topic and all
sais the LC_COLLATE and LC_CTYPE solves it, but it seems not.
Any advice would be helpful.
Thanks in advance,
--
Adam PAPAI
BSD Support Service
http://www.bsdsupportservice.hu
E-mail: adam.papai@bsdsupportservice.hu
Phone: +36 30 33-55-735 (Hungary)
