Re: Sorting in Unicode not working

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.

What can I do next to get sorting working on postgresql?

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Hitesh Bagadiya <bagadiya(at)yahoo(dot)com> writes:
> > We did set the locate to hi_IN at initdb but sorting is not
> > working.
>
> You should check that you have selected a database encoding
> that matches
> what the locale expects. Also double-check that you really do
> have that
> locale selected (use pg_controldata, or in 7.4 just "show
> lc_collate").
>
> 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