On Oct 9, 2011, at 10:46 PM, Black, Michael (IS) wrote: > create virtual table ftext using fts3(t text);
Try this instead: create virtual table ftext using fts4(t text, prefix="1") http://www.sqlite.org/fts3.html#section_6_2 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users