BUG #2592: ILIKE does not care about locales

Поиск
Список
Период
Сортировка
От Robert Siemer
Тема BUG #2592: ILIKE does not care about locales
Дата
Msg-id 200608271258.k7RCw0s3065212@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2592: ILIKE does not care about locales  (Tino Schwarze <tino.schwarze@tisc.de>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged online:

Bug reference:      2592
Logged by:          Robert Siemer
Email address:      Robert.Siemer-postgresql.org@backsla.sh
PostgreSQL version: 8.1.4
Operating system:   Linux
Description:        ILIKE does not care about locales
Details:

Hi!

As I don't want to risk getting things mixed up here in this very report,
lets assume:
s and t are strings with one 'international' character, one having the lower
case the other upper

lower(s) LIKE lower(t) yields True, as it should

s ILIKE t yields False --> I expect True


I tried this with LC_COLLATE=C and the rest LC_...=es_ES.utf8

dennisb from irc reported LC_everything=sv_SE.UTF-8 with version 8.1.0
having the same problems.

Some "non-normative" examples for s and t:
http://rafb.net/paste/results/bMRfez77.html
and ä Ä, ñ Ñ, ö Ö

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

Предыдущее
От: "Gin Indexes cause server to crash on Windows"
Дата:
Сообщение: BUG #2594: Gin Indexes cause server to crash on Windows
Следующее
От: Tino Schwarze
Дата:
Сообщение: Re: BUG #2592: ILIKE does not care about locales