Tim Romano wrote: > Thanks for the correction, Pavel, about the mixed comparison mode > (ASCII-range: case-insensitive, above-ASCII: case-sensitive). > > I've added a column to my table: > > ALTER TABLE WORDS > ADD COLUMN spell varchar COLLATE NOCASE > > and have then copied the contents of a 100% pure ASCII column into > column SPELL. > > explain query plan > select * from WORDS where spell like 'foo%' > > shows that SQLite is still doing full table scan.
Did you create an index on that new column? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users