Problem in unicode sorting

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Problem in unicode sorting

madhu  aggarwal

We have a postgresql database in Hindi and English.
The records are entered in Hindi as well as in English.
The problem is in the sorting of hindi records when we give
select * from table order by name the hindi sorting is not correct.

For that we had intialised the initdb with en_US.UTF-8.

What to do.
We are writing a PHP script for inserting searching and retrieving the records.
Thanx in advance
with regards
Madhu Aggarwal