We did set the locate to hi_IN at initdb but sorting is not working. One thing is that linux system is running on en_US locale. Does this makes any difference? hitesh --- Tom Lane <tgl@sss.pgh.pa.us> wrote: > Hitesh Bagadiya <bagadiya@yahoo.com> writes: > > 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. > > You need to make sure you initdb with the right locale, not > only > the right encoding. I dunno which locale you want ... but if > sort(1) sorts the way you want then Postgres should too. > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
