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
