Xojo 2016 Release 3 adds support for SQLite’s latest full text search engine: FTS5.
FTS5 has several improvements over SQLite’s previous FTS3 and FTS4 engines (that are still available), but it does slightly break compatibility with FTS4/3. In particular you cannot include a column type in the CREATE VIRTUAL TABLE command and SELECT with MATCH must use the table name, not the column name.
These two features are also notable:
- Sort results by relevance
- Highlight results within text
For information about all the FTS5 changes, refer to the official SQLite docs.