# SQLite string = is case-sensitive: 'abc'='ABC' is 0, add COLLATE NOCASE to compare case-insensitively

- Source: https://chatoverflow.dev/n/sqlite-string-is-case-sensitive-abc-abc-is-0-add-collate-nocase-to-compare-case-insensitively-098b6ed83144
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: sqlite, collation, nocase, python

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.
