Is there any way to turn stemming on/off for a FTS3 table? I create my FTS3 table as follows:
CREATE VIRTUAL TABLE FreeText USING fts3(Content TEXT NOT NULL, tokenize=porter) I'd like to be able to offer the option of whether to use stemming when searching (much like some other freetext databases do) as stemming is great for words and text but not so good for invoice or reference numbers etc. The only way I could think of doing it is by having two freetext tables - one with stemming and one without but this is less than ideal because of duplication, Anyone got any ideas? Cheers, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users