Re: Sorting in Unicode not working

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