use ILIKE for case insensitive searches

see https://github.com/owncloud/core/pull/10958

diff --git a/lib/notestorage.php b/lib/notestorage.php
index d1fe7e3b8f99c5d5a723728811f7310063052005..93311e4a4b877f6eadf431e03921c6d90a361f5a 100644 (file)
--- a/lib/notestorage.php
+++ b/lib/notestorage.php
@@ -287,8 +287,8 @@ class NoteStorage
             $keywordGroups['NOT'] = array();
         }
 
             $keywordGroups['NOT'] = array();
         }
 

-        $sqlTplAnd = ' AND (note_title LIKE ? OR note_tags LIKE ? OR note_content LIKE ?)';
-        $sqlTplNot = ' AND NOT (note_title LIKE ? OR note_tags LIKE ? OR note_content LIKE ?)';
+        $sqlTplAnd = ' AND (note_title ILIKE ? OR note_tags ILIKE ? OR note_content ILIKE ?)';
+        $sqlTplNot = ' AND NOT (note_title ILIKE ? OR note_tags ILIKE ? OR note_content ILIKE ?)';

         $arData = array(
             $this->username
         );
         $arData = array(
             $this->username
         );