The following bug has been logged online: Bug reference: 2592 Logged by: Robert Siemer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux Description: ILIKE does not care about locales Details:
Hi! As I don't want to risk getting things mixed up here in this very report, lets assume: s and t are strings with one 'international' character, one having the lower case the other upper lower(s) LIKE lower(t) yields True, as it should s ILIKE t yields False --> I expect True I tried this with LC_COLLATE=C and the rest LC_...=es_ES.utf8 dennisb from irc reported LC_everything=sv_SE.UTF-8 with version 8.1.0 having the same problems. Some "non-normative" examples for s and t: http://rafb.net/paste/results/bMRfez77.html and ä Ã, ñ Ã, ö à ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
