Tim Romano <tim.rom...@yahoo.com> wrote: > A revised question (sorry for leaving out an important fact on the > first go): > > When the default binary collation is being used, why does the > optimizer not attempt to use an index when the WHERE > clause uses the LIKE operator with a text column, as in: > > ... where myTextColumn like 'M%'
Because LIKE is case insensitive by default, while BINARY collation is case sensitive. > I /believe/ case_sensitive_like is OFF. Precisely. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
