Re: Sorting in Unicode not working - Mailing list pgsql-general

From Hitesh Bagadiya
Subject Re: Sorting in Unicode not working
Date
Msg-id 20040411083034.83424.qmail@web12309.mail.yahoo.com
Whole thread Raw
In response to Re: Sorting in Unicode not working  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks for your help. The command shows that the locale is
en_US. Now I will try to figure out how to correctly set locale
to hi_IN.

hitesh



--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Hitesh Bagadiya <bagadiya@yahoo.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

pgsql-general by date:

Previous
From: CSN
Date:
Subject: Re: system date != now()
Next
From: Francisco Reyes
Date:
Subject: Re: \? not working in psql