On Oct 10, 2007, at 2:12 PM, [EMAIL PROTECTED] wrote:
"Peter A. Friend" <[EMAIL PROTECTED]> wrote:
As near as I can tell from the documentation, the only difference
between LIKE and GLOB is the wildcard character and that LIKE is
case-
insensitive (unless configuration overrides that). Is there some
detail about the behavior of LIKE that I have missed?
See http://www.sqlite.org/optoverview.html#like_opt
Ah, I had read that but obviously not close enough. So basically,
since the SQL standard requires LIKE to be case-insensitive and the
default collating sequence is BINARY, the LIKE optimization gets
disabled. The only way to allow for LIKE to be optimized *and*
provide a case-insensitive match is to use the NOCASE collation.
Many thanks,
Peter
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------