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
Hi,
I'm using SQLite 3.7.12 and I'm trying to build an fts phrase query to
match a string containing a double-quote.
Given the table created by the following commands:
- create virtual table tbl using fts4(txt);
- insert into tbl values ('quoted'), ('quoted');
I have tried to search for
On Mon, Jun 18, 2012 at 12:10 PM, Carl Desautels
carlin.desaut...@senecacollege.ca wrote:
Hi,
I'm using SQLite 3.7.12 and I'm trying to build an fts phrase query to
match a string containing a double-quote.
Double-quote is syntactically significant to FTS3 - it delimits two or more
word in
On Mon, Jun 18, 2012 at 12:57 PM, Richard Hipp d...@sqlite.org wrote:
Double-quote is syntactically significant to FTS3 - it delimits two or more
word in a phrase search. You cannot search for words that contain
double-quote using FTS3.
Thank you
--
Carlin W. Desautels
Research Assistant