Skip site navigation (1) Skip section navigation (2)

Re: BUG #3394: Partial search not working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Murali Doss" <Murali(dot)Doss(at)mphasis(dot)com>
Cc: "Douglas Toltzman" <doug(at)oakstreetsoftware(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3394: Partial search not working
Date: 2007-06-19 14:20:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
"Murali Doss" <Murali(dot)Doss(at)mphasis(dot)com> writes:
> I have created new database with encoding as sql_ascii and reloaded the
> data but still its returning 0 rows in Linux.

It's locale, not encoding (or not only encoding) that determines sort
order.  It sounds to me like you are using C locale on the other
installations but some non-C locale on the Linux one.  In C locale
"BA" is between "B-" and "B~" but in most other locales it's not.

Check LC_COLLATE setting to find out.  If it's wrong you'll have to
re-initdb :-(

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: nasim.sindriDate: 2007-06-20 06:29:19
Subject: commit transaction failed
Previous:From: Murali DossDate: 2007-06-19 14:05:13
Subject: Re: BUG #3394: Partial search not working

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group