function Connection::sqlFunctionLikeBinary

Same name in other branches
  1. 9 core/modules/sqlite/src/Driver/Database/sqlite/Connection.php \Drupal\sqlite\Driver\Database\sqlite\Connection::sqlFunctionLikeBinary()
  2. 10 core/modules/sqlite/src/Driver/Database/sqlite/Connection.php \Drupal\sqlite\Driver\Database\sqlite\Connection::sqlFunctionLikeBinary()
  3. 11.x core/modules/sqlite/src/Driver/Database/sqlite/Connection.php \Drupal\sqlite\Driver\Database\sqlite\Connection::sqlFunctionLikeBinary()

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/lib/Drupal/Core/Database/Driver/sqlite/Connection.php, line 322

Class

Connection
SQLite implementation of \Drupal\Core\Database\Connection.

Namespace

Drupal\Core\Database\Driver\sqlite

Code

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);
}

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.