On 17/05/2021 11.38, Илья Хайбуллин wrote:

ILKE works case-insensitively - that's good, thank you very much. But the question about the translation to lowercase is still relevant.

I'm not denying that, but it's good to know that this is at least a work around, and that the code implementing the ILIKE operator is good enough so that it might be used as the basis for the lower function. In any case, can you report this on our bug tracker, please. https://bugs.monetdb.org (which should redirect you to github).

17.05.2021, 12:15, "Sjoerd Mullender" :

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

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

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

-- Sjoerd Mullender