Re: BUG #2554: ILIKE operator works incorrectly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #2554: ILIKE operator works incorrectly
Дата
Msg-id 27292.1154645929@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #2554: ILIKE operator works incorrectly  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-bugs
Peter Eisentraut <peter_e@gmx.net> 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #2554: ILIKE operator works incorrectly
Следующее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Fwd: Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)