How to implement case insensitive search in python?

Question

Python

In an asynchronous web application, I make case-insensitive queries against a database (aiosqlite) to look up a full name from a list of real-time profiles:

async def query(*args):
    name,lastname = [x.upper()+"%" for x in args]
    async with aiosqlite.connect(Host.DBPATH) as db:
            cursor = await db.execute("SELECT * FROM profile WHERE UPPER(name) LIKE ? OR UPPER(lastname) LIKE ?",(name,lastname))
            return await cursor.fetchall()

Like many, it was a surprise to me that the search in Russian would not work.
I would like to ask how to implement an asynchronous case-insensitive search on several database fields (currently sqlite, but you can move)?

If I understand correctly, aiosqlite does not support other encodings, right?

NO CASE COLLATE tried - does not work.

The app is connected to heroku via pipelines.

Answer 1

You can, as a quick solution, duplicate the data in the table, processing it from the outside with an upper case transformation.
Then you will have to submit already converted (prepared for the index format) data to the input to the queries.
And here there is an article on how to add collate for Russian case-insensitive comparison.

Answer 2

As for many, it was a surprise for me that the search in Russian would not work.

This is a sqlite issue.
You can first create a request with your hands and check the functionality with your hands.