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" sjoerd@monetdb.org:

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