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.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.