"Murali Doss" <Murali.Doss@mphasis.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