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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
