On 09/09/2015 07:56 PM, Lohmann, Niels, Dr. (CQTN) 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'*".
I don't think there is a foolproof way to do that with FTS4. Enclosing
the text in double-quotes might help, but then there is no way to escape
embedded double quotes.
In FTS5 you can enclose tokens in double quotes and escape embeded quote
characters in the usual SQL way (by doubling them). i.e.
... MATCH '"TEST.*"'
Or for {TEST"*}:
... MATCH '"TEST""*"'
Dan.
>
> All the best
> Niels
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
