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:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
