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 r=LpSolit, a=mkanat --- Bugzilla/DB/Mysql.pm | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'Bugzilla/DB') 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