Is SQLite case-sensitive by default?

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.

Does SQLite in case insensitive?

The important point to be noted is that SQLite is case insensitive, i.e. the clauses GLOB and glob have the same meaning in SQLite statements.

How do I make SQLite 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 table name case-sensitive?

2 Answers. Show activity on this post. SQL is case insensitive. You can use lower or uppercase characters.

Does SQLite have case?

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

Expert · Answer