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?