Re: Sorting in Unicode not working

From: Hitesh Bagadiya <bagadiya(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting in Unicode not working
Date: 2004-04-11 08:30:34
Message-ID: 20040411083034.83424.qmail@web12309.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jerry McBride 2004-04-11 16:06:38 Re: Data Encryption in PostgreSQL, and a Tutorial.
Previous Message CSN 2004-04-11 07:01:42 Re: system date != now()