On 06/01/2011 06:30 AM, Mohd Radzi Ibrahim wrote: > Hi, > I was searching for any reference to reserved characters used in FTS4, but > failed to find any. > > I have problem with query with - ftstable match 'width 5" ' > > But it's ok with - ftstable match 'width 5' > > to fix this, I replaces every double-qoute in query with empty space. > > My question, is there any other characters that has special meaning in FTS > match query?
Those mentioned in the query syntax here: http://www.sqlite.org/fts3.html#section_3 The query parser is probably confusing the unmatched '"' character for the start of a quoted phrase. I guess you also have to watch out for '-', '*' and ':'. Also the uppercase keywords AND, OR, NOT and NEAR. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users