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