On Mon, Jun 18, 2012 at 12:10 PM, Carl Desautels <
[email protected]> 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 a phrase search. You cannot search for words that contain
double-quote using FTS3.
>
> Given the table created by the following commands:
>
> - create virtual table tbl using fts4(txt);
> - insert into tbl values ('quot"ed'), ('quoted');
>
> I have tried to search for "quot"ed" in the following ways and provided
> their respective errors:
>
> - match('"*\"*"')
> - Error: malformed MATCH expression: ["*\"*"]
> - match('"*"*"')
> - Error: malformed MATCH expression: ["*"*"]
> - match('"*\\"*"')
> - Error: malformed MATCH expression: ["*\\"*"]
> - match('"*\\\"*"')
> - Error: malformed MATCH expression: ["*\\\"*"]
>
> --
> Carlin W. Desautels
> Research Assistant
> Seneca's Centre for Development of Open Technology
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
