How to do case insensitive searches in Rails?

Question

Ruby on Rails

I use the following construction where('lower(name) LIKE ?', "%#{name}.downcase)%"), but for some reason downcase doesn't work and gives out the string I entered

Answer 1

Horrible.
1. See the resulting query (interpolation does not work).
2. Use ILIKE instead of manually doing everything.
3. What is the base?

Answer 2

downcase does not work with Cyrillic, you can do this:str.mb_chars.downcase

Answer 3

Well, you have an error in the code:
where('lower(name) LIKE ?', "%#{name}.downcase)%") - the query will be "WHERE lower(name) LIKE '%Name.downcase)%'"