=?UTF-8?B?IkzDoXN6bMOzLVLDs2JlcnQsIEFsYmVydCI=?= <[EMAIL PROTECTED]> writes:
> [ ILIKE fails to match case-insensitively in 8.1.2 ]
The ILIKE code doesn't work well at all in multibyte encodings in 8.1
and before. You should get reasonable results in one of the LATINn
encodings (and a matching locale of course). If you need to use UTF8,
I recommend updating to 8.2 which handles multibyte characters better.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
