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
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list