-1

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

user595985
  • 1,543
  • 4
  • 29
  • 55
  • I have seen the documentation which specifies that the 6 parameter can be used. I have tried a few configurations, but I don't seem to be getting any results. i.e the snippet that comes back remains unchaged just the default number of characters is returned. Anyone with a working example. I have tried SELECT snippet(text, '[ ']', '...',,,,64) FROM text WHERE text MATCH '"min* tem*"' is that wrong? – user595985 Jul 09 '15 at 18:44

1 Answers1

0

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

CL.
  • 173,858
  • 17
  • 217
  • 259