"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
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: nasim.sindri||Date: 2007-06-20 06:29:19|
|Subject: commit transaction failed|
|Previous:||From: Murali Doss||Date: 2007-06-19 14:05:13|
|Subject: Re: BUG #3394: Partial search not working|