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 ('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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
