case insensitive match in unicode

Поиск
Список
Период
Сортировка
От SunWuKung
Тема case insensitive match in unicode
Дата
Msg-id MPG.1e91cf53b3a5581989692@news.postgresql.org
обсуждение исходный текст
Ответы Re: case insensitive match in unicode
Список pgsql-general
I would need to do case insensitive match against a field that contains
text in different languages - Greek, Hungarian, Arabic etc.
The db encoding is UTF8.

So far I found no way to achieve that. I tried converting both strings
to the same case and using ~* , but neither worked.

Does anybody no a way to do this?

Thanks for the help.
Balázs

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