From 0a566f92417aa741828413b00585f48f72b5c639 Mon Sep 17 00:00:00 2001
From: "mkanat%bugzilla.org" <>
Date: Mon, 30 Jun 2008 02:23:10 +0000
Subject: Bug 327344: Create sql_iposition and use it in Search.pm to fix the
 fact that searching for Turkish characters didn't do case-insensitivity
 properly. Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit,
 a=mkanat

---
 Bugzilla/DB/Mysql.pm | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'Bugzilla/DB/Mysql.pm')

diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm
index 80f1cd793..8a64d3646 100644
--- a/Bugzilla/DB/Mysql.pm
+++ b/Bugzilla/DB/Mysql.pm
@@ -183,13 +183,14 @@ sub sql_interval {
     return "INTERVAL $interval $units";
 }
 
-sub sql_position {
+sub sql_iposition {
     my ($self, $fragment, $text) = @_;
+    return "INSTR($text, $fragment)";
+}
 
-    # mysql 4.0.1 and lower do not support CAST
-    # (checksetup has a check for unsupported versions)
+sub sql_position {
+    my ($self, $fragment, $text) = @_;
 
-    my $server_version = $self->bz_server_version;
     return "INSTR(CAST($text AS BINARY), CAST($fragment AS BINARY))";
 }
 
-- 
cgit v1.2.3-24-g4f1b