PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting
| От | Adam PAPAI |
|---|---|
| Тема | PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting |
| Дата | |
| Msg-id | 4D4D8385.6090805@bsdsupportservice.hu обсуждение |
| Ответы |
Re: PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is
not correct sorting
|
| Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: