From 2c90a9f238ae50a870072398f0dbe32360018ccd Mon Sep 17 00:00:00 2001
From: tokul <tokul@7612ce4b-ef26-0410-bec9-ea0150e637f0>
Date: Tue, 18 May 2004 13:07:49 +0000
Subject: [PATCH] using case insensitive lookups that don't depend on sql
 server string comparison options. mysql tested by me, postgresql tested by
 Patrick Welche <prlw1 at newn.cam.ac.uk>

git-svn-id: https://svn.code.sf.net/p/squirrelmail/code/trunk/squirrelmail@7484 7612ce4b-ef26-0410-bec9-ea0150e637f0
---
 functions/abook_database.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/functions/abook_database.php b/functions/abook_database.php
index 5fdd0d60..94a9180e 100644
--- a/functions/abook_database.php
+++ b/functions/abook_database.php
@@ -173,7 +173,7 @@ class abook_database extends addressbook_backend {
             return false;
         }
          
-        $query = sprintf("SELECT * FROM %s WHERE owner='%s' AND nickname='%s'",
+        $query = sprintf("SELECT * FROM %s WHERE owner='%s' AND LOWER(nickname)='%s'",
                          $this->table, $this->owner, $this->dbh->quoteString($alias));
 
         $res = $this->dbh->query($query);
-- 
2.25.1