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,


To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to