Tom Lane wrote: > =?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 > > the administrator finally configured properly the postgres 8.2, and the reported problem looks to be fixed. i ran successfully the ILIKE test on hungarian language. thanks for the tip. regards, laszlo-robert, albert
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
