Sorting in Unicode not working - Mailing list pgsql-general

From Hitesh Bagadiya
Subject Sorting in Unicode not working
Date
Msg-id 20040409080520.58295.qmail@web12308.mail.yahoo.com
Whole thread Raw
Responses Re: Sorting in Unicode not working
List pgsql-general
Hi,

Our database contains Hindi as well as English characters. We
have specified the encoding to be unicode during initdb as well
as createdb commands.

Unfortunately sorting of the Hindi fields is not working. For
e.g. we have a person table and the query "SELECT * FROM PERSON
ORDERY BY LASTNAME" returns all the rows but the records are not
being sorted by the last name.

We tried this on Postgresql 7.3.2 as well as 7.4.1 but with no
luck. The OS we tried were Mandrake 9.1 and Fedora Core 1.

Do we need to do anything special to get Hindi/Unicode sorting
working in Postgresql?

Please help,

Hitesh


__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/

pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: Select/Group by/Order by question
Next
From: "John Hagstrand"
Date:
Subject: Re: ERROR: invalid memory alloc request size 0