[sqlalchemy] SQLAlchemy case insensitive like for unicode word

Hello! I have gtk application with sqlite db, contain russian words. My model code class Patient(Base): lastname = Column(Unicode) /code Search operation code patients = self.session.query(Patient) lastname = unicode(self.lastname_entry.get_text()) if lastname: patients =

Re: [sqlalchemy] SQLAlchemy case insensitive like for unicode word

That's SQLite's lower() function. If you'd like to use Python's lower() function, you should call lower() on the string and use column.like(mystring.lower()). But that won't do case-insensitive comparison since you need to call lower() on the database column in the statement. So you really