Sql like Russian words case insensitive in rails?

Question

Ruby on Rails

There was a problem, when querying the database, Russian (Cyrillic) words are compared case-sensitive, although at the same time Latin is compared case-insensitively.
Tried to defeat this with .mb_chars.downcase.to_sand lowerin the query, but to no avail.

where('lower(first_name) like ?', name).mb_chars.downcase.to_s<br>

Suggest a solution to this problem

Answer 1

I figured out that this is a feature of sqlite, by default the lower function in it does not work for UTF-8, you need to either write your own function or take an sqlite assembly with unicode support. On production with mysql everything works.

Answer 2

What is the encoding in your database, not bin by any chance?

Answer 3

version of ruby, rails and the resulting sql query from the logs.