9

Sqlite FTS get matched terms

view full story
linux-howto

http://stackoverflow.com – I am using FTS4 in my android app, however for highlighting purposes I need to know a unique list of terms that sqlite has matched. For example, if I search "app*" that will match "apps" "apple" etc. How can I obtain this list? One answer might be, why do I need these words when I have the offsets. Well I tried to highlight using offsets, however for some reason they are inaccurate for my text. Some characters take more bytes than others it seems and it just does not work out. So I am manually finding the words 1 at a time and highlighting them. (HowTos)