Re: string comparison problem

On 08/01/11 11:12 AM, Johnny Edge wrote:
> I have a problem with identical versions of postgresql - 8.3.13
> Config files are identical. HostA is a 32 bit CentOS 5.3 install and
> the hostB is x86_64 CentOS 6.
> Difference in architecture should not be a problem - I have another 64
> bit CentOS where both queries are executed displaying identical results.
> However, libraries which postgresql is compiled against on host B are
> significantly newer.
> Any thoughts how can this be resolved?
> PostgreSQL is compiled from source on both servers.

same client encoding on both instances?

     SHOW CLIENT_ENCODING;
     SHOW LC_COLLATE;





--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast