Black, Michael (IS) <michael.bla...@ngc.com> wrote: > 3.7.4 doesn't indicate it will use an index in either case with like...but > glob seems to call the index...why does glob use the > index but like does not?
LIKE is case-insensitive by default, while GLOB is case-sensitive. Thus, LIKE works with NOCASE collation while GLOB wants BINARY collation. The document I cited discusses all this in detail. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
