Are SQLite queries case-sensitive?

Question

Important Note: SQLite only understands upper/lower case for ASCII characters by default. The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range. For example, the expression 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE.

How do I make SQLite query case insensitive?

To be case insensitive on firstname , write this: select * from tbl where firstname='john' COLLATE NOCASE and lastname='doe' . It's specific to that one column, not the entire where clause.

Is SQLite case-sensitive on table name?

In reality sqlite3 names are case insensitive.

Does SQLite have case?

SQLite provides two forms of the CASE expression: simple CASE and searched CASE .

Does case matter in SQL query?

The SQL Keywords are case-insensitive ( SELECT , FROM , WHERE , etc), but are often written in all caps. However in some setups table and column names are case-sensitive.

Expert · Answer