From 6055a3dc5aba51e14d03b920025ce03d49371713 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 14 Mar 2007 00:02:14 +0000 Subject: [PATCH] Use LOWER, not LCASE --- includes/SpecialImagelist.php | 2 +- includes/SpecialNewimages.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/SpecialImagelist.php b/includes/SpecialImagelist.php index 84cbfce5b3..390fb54d04 100644 --- a/includes/SpecialImagelist.php +++ b/includes/SpecialImagelist.php @@ -43,7 +43,7 @@ class ImageListPager extends TablePager { $m = $dbr->strencode( strtolower( $nt->getDBkey() ) ); $m = str_replace( "%", "\\%", $m ); $m = str_replace( "_", "\\_", $m ); - $this->mQueryConds = array( "LCASE(img_name) LIKE '%{$m}%'" ); + $this->mQueryConds = array( "LOWER(img_name) LIKE '%{$m}%'" ); } } diff --git a/includes/SpecialNewimages.php b/includes/SpecialNewimages.php index 817d64972a..1e114b3605 100644 --- a/includes/SpecialNewimages.php +++ b/includes/SpecialNewimages.php @@ -80,7 +80,7 @@ function wfSpecialNewimages( $par, $specialPage ) { $m = $dbr->strencode( strtolower( $nt->getDBkey() ) ); $m = str_replace( '%', "\\%", $m ); $m = str_replace( '_', "\\_", $m ); - $where[] = "LCASE(img_name) LIKE '%{$m}%'"; + $where[] = "LOWER(img_name) LIKE '%{$m}%'"; $searchpar = '&wpIlMatch=' . urlencode( $wpIlMatch ); } } -- 2.20.1