Many thanks guys !! Everyone who suggested cause of problem due to LC_COLLATE setting C was correct. Problem is resolved. Apologies for the multiple post. Kind regards, JE -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John R Pierce Sent: Monday, August 01, 2011 10:58 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
