=?UTF-8?B?IkzDoXN6bMOzLVLDs2JlcnQsIEFsYmVydCI=?= <albertlaszlorobert(at)gmail(dot)com> 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