"Tim Romano" <tim.rom...@yahoo.com> schrieb im Newsbeitrag news:4b017343.2040...@yahoo.com...
> 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 column "spell" beforehand? (In that case, since you already gave the Collation in the Column-Def, you would not need to give the NoCase- Collation explicitely again in the Create Index-Statement). > QUESTION: > Is it possible to confirm that the column actually has been created > with NOCASE collation? Why not just test, what a simple Select gives as a result of e.g.: Select spell From Words Where spell = 'abc' Limit 1 In case column spell contains a "known word" as 'Abc' for example, you should get back a resulting row - if NoCase wouldn't have been recognized correctly, you shouldn't get back a string-result (a resulting row) from that query (in such a case-insensitivity-provocing Comparison-Attempt). Olaf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users