From 372fa85dd33e4ee4daf4286f0379e33354904029 Mon Sep 17 00:00:00 2001 From: Phie Date: Wed, 17 Apr 2019 15:38:15 +0200 Subject: fix search with sqlite --- lib/Misc/CacheManager.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/Misc/CacheManager.php b/lib/Misc/CacheManager.php index e3535f8..d18caa9 100644 --- a/lib/Misc/CacheManager.php +++ b/lib/Misc/CacheManager.php @@ -129,7 +129,7 @@ class CacheManager{ public function search($query){ $arrayFullPath = array(); $sql = 'SELECT * FROM `*PREFIX*carnet_metadata` ' . - 'WHERE path LIKE ? AND CONVERT(metadata USING utf8) LIKE _utf8 ? COLLATE utf8_general_ci'; + 'WHERE path LIKE ? AND metadata LIKE ? '; $args = array(); array_push($args, $this->carnetFolder->getPath()."/%"); -- cgit v1.2.3