With the default tokenizer your index would split such an input (quot'ed) into 'quot' and 'ed' , you wouldn't get a hit for a phrase such as "quot''ed". If you use a custom tokenizer , you CAN use " in your terms/queries, however it won't work for phrases, only for single tokens
>From the fts3aux.c source: /* See if we are dealing with a quoted phrase. If this is the case, then ** search for the closing quote and pass the whole string to getNextString() ** for processing. This is easy to do, as fts3 has no syntax for escaping ** a quote character embedded in a string. */ -- View this message in context: http://sqlite.1065341.n5.nabble.com/Building-an-fts-Query-for-Double-Quote-tp62541p62545.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
