Re: for the Cyrillic alphabet, lower does not work

Does it work to use ILIKE instead of LIKE or = to do the comparison? I.e. something like: select col ILIKE '%UPPER%' (or '%lower%')? On 17/05/2021 09.40, Илья Хайбуллин wrote:

Good afternoon. It is necessary to perform a normal search on a string column without taking into account the case. Like this: lower(text_column) like ('%lower_text%'). However, the result of running "lower" is not satisfactory for the Cyrillic alphabet. select lower ('dsMKjhовЛДРВвы'); dsmkjhовЛДРВвы That is, for the Cyrillic alphabet, lower does not work Are there any ways to solve this problem?

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- Sjoerd Mullender