Thanks for a quick answer. On Tuesday, 12 February 2013, Richard Hipp wrote:
> On Tue, Feb 12, 2013 at 5:50 PM, Mike King > <making1...@gmail.com<javascript:;>> > wrote: > > > 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? > > > > The index is over the stemmed words. So if you change the stemmer (or turn > if off completely) then you have to recreate the index. > > So, yes, the only way to do this is to have two tables, one with stemming > and the other without. > > -- > D. Richard Hipp > d...@sqlite.org <javascript:;> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org <javascript:;> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users