caseSensitiveLike

Queries or sets the case_sensitive_like flag.

This pragma controls the case-sensitivity of the built-in LIKE operator. By default, LIKE is case-insensitive for ASCII characters.

• When set to true, the LIKE operator becomes case-sensitive.

• When set to false (the default), it remains case-insensitive.

This pragma only affects the built-in LIKE function. It does not affect custom LIKE functions or the GLOB operator.

See also