sqlite3_fts5 error when using punctuation

Question

I have a question string variable that contains the word "Where is my car?"

when I try and run a select on this it crashes.

String sql = "Select * from tblHALv2001 WHERE tblHALv2001 MATCH '" + question + "'";

fts5: syntax error near "?"

If I remove the question mark from the question variable then it works. But how can I correct the statement so it doesn't crash?

and this is driving me crazy. I have tried every combination I can think of but no matter what, if I use ' or ? in the query text it falls over. — maximdj, Oct 02 '17 at 14:46
SQL logic error or missing database fts5: syntax error near "?" — maximdj, Oct 02 '17 at 14:57

score 2 · Answer 1 · answered Oct 02 '17 at 16:37

2

You cannot simply use any random string with FTS; MATCH expects an FTS query as its right operand.

You could use double quotes to escape the question mark, but then the tokenizer would ignore it anyway.

answered Oct 02 '17 at 16:37

CL.

would you be able to give me an example of the double quotes? – maximdj Oct 02 '17 at 16:49
This is how I created my virtual table: – maximdj Oct 02 '17 at 16:49
sql = "create VIRTUAL TABLE tblvHAL2001 USING fts5(question,answer,action,keywordPriority,keyword,keyword2,attach,tokenize=porter)"; – maximdj Oct 02 '17 at 16:49

1 Answers1