From c8c765c0ab435d03249bb555cdc40a5d26404302 Mon Sep 17 00:00:00 2001
From: cataluke <cataluke>
Date: Tue, 17 Apr 2007 05:41:31 +0000
Subject: [PATCH] MDL-7856 - make database search case-insensitive for
 PostgreSQL too.

Author: Andrew Walbran <andrew.walbran@catalyst.net.nz>
Committer: Luke Hudson <luke@catalyst.net.nz>
---
 mod/data/view.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/data/view.php b/mod/data/view.php
index 26e5493058..02e14c9430 100755
--- a/mod/data/view.php
+++ b/mod/data/view.php
@@ -394,7 +394,7 @@
                 }
             }
             elseif ($search) {
-                $searchselect = ' AND (dc.content LIKE "%'.$search.'%") ';
+                $searchselect = ' AND (c1.content ' . sql_ilike() . " '%$search%') "; //Be case-insensitive
             } else {
                 $searchselect = ' ';
             } 
@@ -416,7 +416,7 @@
                 }
             }
             else {
-                $searchselect = ' AND (c.content LIKE "%'.$search.'%") ';
+                $searchselect = ' AND (c.content ' . sql_ilike() . " '%$search%') "; //Be case-insensitive
             }
 
             
-- 
2.39.5