Michael, I certainly understand why this hasn't been added. With some
databases like sqlite, a case sensitive search isn't even possible.
This is much more complicated that I would have imagined.
--~--~-~--~~~---~--~~
You received this message because you are
Hi,
Maybe I'm not understanding this. Is ILIKE only a mysql thing? So is
LIKE normally case insensitive in complaint SQL database?
ILIKE is quasi-standard. Postgres has it as well, but MSSQL doesn't -
all LIKEs (and in equals too in fact) are case insensitive.
Paul
Normally, like is case sensitive.
if you want to query something case insensitive, one can use all kinds
of expressions, one that comes to mind would be
lower(col) like 'lowercase%'
creating indexes on lower(col) would speed that up.
Andreas
* Paul Kippes [EMAIL PROTECTED] [070404 20:07]:
* Paul Johnston [EMAIL PROTECTED] [070404 20:11]:
Hi,
Maybe I'm not understanding this. Is ILIKE only a mysql thing? So is
LIKE normally case insensitive in complaint SQL database?
ILIKE is quasi-standard. Postgres has it as well, but MSSQL doesn't -
all LIKEs (and in equals too
theres a whole bunch of crap regarding case sensitivity in compares.
at this point ive been asked about three thousand times for ILIKE so
sure, we can add it...if we are adding a Like() construct, with a
visit_like() in compiler, thats great; DB's that dont have ILIKE can
pull out