public static function Connection::sqlFunctionLikeBinary in Drupal 10
SQLite compatibility implementation for the LIKE BINARY SQL operator.
SQLite supports case-sensitive LIKE operations through the 'case_sensitive_like' PRAGMA statement, but only for ASCII characters, so we have to provide our own implementation with UTF-8 support.
See also
https://sqlite.org/pragma.html#pragma_case_sensitive_like
https://sqlite.org/lang_expr.html#like
File
- core/
modules/ sqlite/ src/ Driver/ Database/ sqlite/ Connection.php, line 343
Class
- Connection
- SQLite implementation of \Drupal\Core\Database\Connection.
Namespace
Drupal\sqlite\Driver\Database\sqliteCode
public static function sqlFunctionLikeBinary($pattern, $subject) {
// Replace the SQL LIKE wildcard meta-characters with the equivalent regular
// expression meta-characters and escape the delimiter that will be used for
// matching.
$pattern = str_replace([
'%',
'_',
], [
'.*?',
'.',
], preg_quote($pattern, '/'));
return preg_match('/^' . $pattern . '$/', $subject);
}