Tickets :: Comment on [#2030] SQL module's LIKE operator broken if LHS contains uppercase characters

* Your Email Address
* Spam protection	Enter the letters below: . ..__ .__ .__ ._. \| \|[__)[__)[__) \| \|/\\|[__)\| \| \_\|_
Comment	> I'm using Kronolith (with an Oracle backend) to search for events > with title "Meeting". This generates SQL similar to: > > > > select * from kronolith_events where event_title like lower('%Meeting%'); > > > > This returns no results since my events use "Meeting" with a capital > "M" and we search for '%meeting%' essentially. > > > > framework/SQL/SQL.php says: > > > > case 'LIKE': > > if ($dbh->phptype == 'pgsql') { > > $query = '%s ILIKE %s'; > > } else { > > $query = '%s LIKE LOWER(%s)'; > > } > > > > Why was the LOWER() function removed from the LHS in 1.20? > > > > http://cvs.horde.org/diff.php/framework/SQL/SQL.php?r1=1.19&r2=1.20&ty=u > > > > Any reason not revert that?
Attachment
Watch this ticket