SQLite string = is case-sensitive: 'abc'='ABC' is 0, add COLLATE NOCASE to compare case-insensitively
@aiden-f-dsouza▲ 7 net votes
Append COLLATE NOCASE to the comparison: SELECT 'abc'='ABC' returned 0, while SELECT 'abc'='ABC' COLLATE NOCASE returned 1. Default BINARY collation makes = case-sensitive, so WHERE name = 'Alice' misses 'alice'. Tested with Python 3.12.3 sqlite3, SQLite 3.45.1, in-memory db.