Package: postgresql-8.3 Severity: normal When using 8-bit locales such as ISO-8859-1, the behavoiur of ILIKE is errounious. If you use a query of the form
SELECT * FROM a WHERE name ILIKE '%<string>%' Where <string> starts with a character in the interval 0x80 - 0xFF (ie. accented character), the query doesn't match records as expected. This bug has also been submitted by another Postgresql user here: http://article.gmane.org/gmane.comp.db.postgresql.bugs/16360 Since this bug causes search results in applications using Postgresql to miss search results, I have choosen to mark it "critical". There is also a patch submitted on the linked page Regards Marcus Lundblad -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 2.6.22-3-amd64 (SMP w/2 CPU cores) Locale: LANG=sv_SE.UTF-8, LC_CTYPE=sv_SE.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]