How to implement a substring search in a string from a model case-insensitive in sqlite in Cyrillic?

Question

Django

I have a model with a CharField field:

class catalogModel(models.Model):
    title = models.CharField('Name', max_length = 100, null = True)

and I need to search through the catalogModel models using the title field, case insensitive

# поисковой запрос
search = request.GET['search']
catalogModel.objects.filter(title__icontains = search)

The only problem is that "__icontains" does not work correctly in "sqlite" with Cyrillic characters (it is case-sensitive, though it shouldn't be).
I was thinking of filtering by title by capitalizing it and the search term, like:

# поисковой запрос
search = request.GET['search']
catalogModel.objects.filter(title__ВЕРХНИЙ_РЕГИСТР__icontains = search.upper())

Answer 1

Make an additional field. In it, everything should be reduced to lower case and search for it.
You can also create title as COLLATE NOCASE