sqlitefts3fts4

How to increase Sqlite FTS4 snippet size


Hi I am using sqlite to do full text search on a number of documents. WHile I've got it working basically but I would very much like to increase/expand the amount of text returned in the snippet, is there a way to increase the size, amount of text that the snippet() returns. I created my fts table using FTS4, I am running python 2.7 on windows 7


Solution

  • As the documentation shows, this can be done with the sixth parameter of the snippet() function.