| From: | Hitesh Bagadiya <bagadiya(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Sorting in Unicode not working |
| Date: | 2004-04-09 08:05:20 |
| Message-ID: | 20040409080520.58295.qmail@web12308.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Hagstrand | 2004-04-09 09:49:01 | Re: ERROR: invalid memory alloc request size 0 |
| Previous Message | Mike Nolan | 2004-04-09 06:23:28 | Re: Select/Group by/Order by question |