Re: russian case-insensitive regexp search not working

Поиск
Список
Период
Сортировка
От alexander lunyov
Тема Re: russian case-insensitive regexp search not working
Дата
Msg-id 46930DB8.8080307@startatom.ru
обсуждение исходный текст
Ответ на Re: russian case-insensitive regexp search not working  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: russian case-insensitive regexp search not working  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
Karsten Hilbert wrote:
> Just to clarify: lower() on both sides of a comparison
> should still work as expected on multibyte encodings ? It's
> been suggested here before.

lower() on both sides also does not working in my case, it still search
for case-sensitive data. String in this example have first char
capitalized, and result is the same. Seems that lower() can't lower
multibyte character.


db=> select lower('Зелен');
  lower
-------
  Зелен
(1 запись)


--
alexander lunyov
lan@startatom.ru


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

Предыдущее
От: "Postgres User"
Дата:
Сообщение: Fastest way to join materalized view to child tables
Следующее
От: "Harpreet Dhaliwal"
Дата:
Сообщение: Duplicate Unique Key constraint error