Black, Michael (IS) <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
