I have a fts4 table(tables_fts) which having title and content column
I want to search "C#" but it's returning only C as highlighted search,
I am using the below sqlite query,
Select snippet(tables_fts,"<"strong">","<"/strong">","<"strong">…<"/strong">",-1,64) as highlight from tables_fts Where tables_fts Match 'C#'
ignore the " inside <"strong">
output:- .....<"strong">C<"/strong">#..........