Hitesh Bagadiya <bagadiya@yahoo.com> writes:
> I set the locale to hi_IN during initdb. pg_controldata and show
> lc_collate both show that locale is hi_IN. But postgresql is not
> returning sorted records.
There's still the other point about whether the database's character
set encoding matches what the locale setting requires.
For that matter, are you certain the locale itself works? Have you
checked that sort(1) produces the sort order you are expecting when
LC_ALL=hi_IN?
regards, tom lane
---------------------------(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
