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