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-10 07:54:29 |
Message-ID: | 20040410075429.59857.qmail@web12306.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We did set the locate to hi_IN at initdb but sorting is not
working. One thing is that linux system is running on en_US
locale. Does this makes any difference?
hitesh
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Hitesh Bagadiya <bagadiya(at)yahoo(dot)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
>
> ---------------------------(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
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Klawitter | 2004-04-10 11:17:49 | Re: Sorting in Unicode not working |
Previous Message | Janning Vygen | 2004-04-10 07:17:22 | Re: Accented chars in several apps |