[dev] Re: [cvs] commit: horde/lib SQL.php

[Roman Neuhauser]

# chuck at horde.org / 2003-09-26 18:44:01 -0700:
> chuck       2003/09/26 18:44:01 PDT
> 
>   Modified files:
>     lib                  SQL.php 
>   Log:
>   try and make sure LIKE is case insensitive. is one of these LOWER()
>   calls unnecessary?
>   
>   Revision  Changes    Path
>   1.19      +3 -3      horde/lib/SQL.php
> 
>   Chora Links:
>   http://cvs.horde.org/diff.php/horde/lib/SQL.php?r1=1.18&r2=1.19&ty=u

    this change prevents the RDBMS from using an index defined on $lhs.
    Plis, I don't have (ready) access to SQL specs, but the online MySQL
    manual seems to imply that LIKE is defined by SQL-99 to be case
    insensitive:
    http://www.mysql.com/doc/en/String_comparison_functions.html

-- 
If you cc me or remove the list(s) completely I'll most likely ignore
your message.    see http://www.eyrie.org./~eagle/faqs/questions.html