I have also tried the query using the same encoding with both the 8.1.5 and
8.1.8 versions and the query is still coming back with different results.
The 8.1.5 shows all records that include upper and lower case while the
8.1.8 shows only the lower case.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, April 02, 2007 12:18 PM
To: Lloyd Mason
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unexplained case insensitive results
"Lloyd Mason" <LloydM@pbsinet.com> writes:
> There appears to be a difference in the results from the following SQL
> statement when run on an 8.1.5 version versus a 8.1.8 version:
I imagine you initdb'd the two installations with different locale
settings. Check "show lc_collate".
regards, tom lane