Thread: Problem in unicode sorting

 
 
 
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