Problem in unicode sorting - Mailing list pgsql-general

From madhu aggarwal
Subject Problem in unicode sorting
Date
Msg-id 20050607111427.10467.qmail@webmail25.rediffmail.com
Whole thread Raw
List pgsql-general

 
 
 
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


pgsql-general by date:

Previous
From: "Jim McMaster"
Date:
Subject: Cannot get PostgreSQL to work with Ruby On Rails
Next
From: Dan Miller
Date:
Subject: FATAL: Sorry, too many clients already????