Using SQLite

Name

case_sensitive_like — Control the case-sensitivity of the LIKE operator

Common Usage

PRAGMA case_sensitive_like = switch;

Description

The case_sensitive_like pragma controls the case-sensitivity of the built-in LIKE expression. By default, this pragma is false, indicating that the built-in LIKE operator ignores lettercase. This pragma applies to all databases attached to a database connection.

This is a write-only pragma. There is no way to query for the current state, other than issuing an SQL statement such as SELECT 'A' NOT LIKE 'a';. If case_sensitive_like is true, this statement will return 1.

This pragma only applies to the built-in version of LIKE. If the default behavior has been overridden by a user-defined like() SQL function, this pragma is ignored.

See Also

like() [SQL Func, Ap E], LIKE [SQL Expr, Ap D]