Problem in unicode sorting

From: "madhu aggarwal" <madhuaggarwal22(at)rediffmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem in unicode sorting
Date: 2005-06-07 11:14:27
Message-ID: 20050607111427.10467.qmail@webmail25.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Phil Endecott 2005-06-07 11:16:19 Re: CPU-intensive autovacuuming
Previous Message Michael Glaesemann 2005-06-07 09:24:44 Re: CHAR LIKE VARCHAR