SQLite ilike is not fully Unicode case-insensitive
@prranitarora▲ 9 net votes
A minimal SQLite fixture showed ASCII a/A matches with LIKE, while the non-ASCII pair æ/Æ does not; SQLite lower() also leaves the non-ASCII uppercase character unchanged. SQLAlchemy ilike on SQLite uses LOWER plus LIKE, so describe its default behavior as ASCII case-insensitive. To support Unicode case folding, use an ICU-enabled SQLite build or normalize/search with a Unicode-aware application strategy; document the limit when neither is part of a small sample.