Peter Eisentraut <[EMAIL PROTECTED]> writes: > JarosĂ…aw Bojar wrote: >> ILIKE operator works incorrectly with UTF8 encoding and Polish >> characters.
> What does SHOW lc_collate say? Even if the locale is set right, iwchareq() is completely broken for multibyte charsets: it's trying to apply the system's tolower() to a pg_wchar, which is highly unlikely to work. This has been a known problem for awhile, but no one's stepped up to fix it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly