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
|
| Список | 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 по дате отправления: