FTS3/4 replaces non-alphanumeric characters with spaces. I do the same for strings that I match in my applications. Something like:
preg_replace('/[^\*\da-z\x{0080}-\x{FFFF}]/ui', ' ', $string); On Wed, Sep 9, 2015 at 7:56 AM, Lohmann, Niels, Dr. (CQTN) <niels.lohmann at carmeq.com> wrote: > Hi there, > > I have a question regarding the expressions that are valid after MATCH: Is > there a way to escape a string str such that I can safely bind it to variable > @var in a statement like "SELECT * FROM myFtsTable WHERE myFtsTable MATCH > @var;"? > > In particular, I encountered error messages with strings like "TEST.*" or > "TEST'*". > > All the best > Niels > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users