There was a somehow recent change in the snippets algorithm, it used to return snippets from a number of columns in a single row if there were multiple matches, separated with "...". Now, it will try to find a fragment of the row that contains ALL search terms, using snippets from the other columns only if such a fragment (which contains all terms) can't be found.
For the second question, all the terms saved on a fts table are tokenized before going into the index - and so are your search terms. The default "simple" tokenizer will strip punctuation, special characters, etc. If you need to store and search such terms, you can create your own tokenizer and attach it to your fts table. More info on both topics can be found on the docs : http://www.sqlite.org/fts3.html -- View this message in context: http://sqlite.1065341.n5.nabble.com/FTS4-Questions-tp62323p62343.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
