From 3e3d460729c515e5723587abc30b4d7955173d12 Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Tue, 8 Jul 2014 12:41:28 +0200 Subject: [PATCH] use case insensitive LIKE when searching for files in mysql --- lib/private/files/cache/cache.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/lib/private/files/cache/cache.php b/lib/private/files/cache/cache.php index 72af474adf8..cfa3e916185 100644 --- a/lib/private/files/cache/cache.php +++ b/lib/private/files/cache/cache.php @@ -472,6 +472,8 @@ class Cache { $sql .= 'REGEXP_LIKE(`name`, ?, \'i\')'; } else if($dbtype === 'pgsql') { $sql .= '`name` ILIKE ?'; + } else if ($dbtype === 'mysql') { + $sql .= '`name` COLLATE utf8_general_ci LIKE ?'; } else { $sql .= '`name` LIKE ?'; } -- 2.39.5