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%' On my system, an index is used with the query above only when collation is "collation nocase". When the default binary collation is used, the identical query with LIKE operator in the WHERE clause does a full table scan. In other words, the only thing that is different is the collation of the column. I /believe/ case_sensitive_like is OFF. I've done nothing to change turn it on. How can I be sure? Thanks Tim Romano _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
