Hello there,

I was running some queries using FTS5 in my database and I generally
sanitize the input by removing non-ascii characters, except for all the
unicode chars above 128 or so. That way I get rid of stuff like quotes,
double quotes, periods, etc.

However my queries where choking on some input that contained the U+2018
and U+2019 characters. It seems like these chars are being treated like
a regular quote character (I get the same error as if I replaced it with
a regular quote character). Is this intended behaviour? The error I'm
getting is "Result: fts5: phrase queries are not supported
(detail!=full" (and a SQLITE_ERROR calling step()).

I'm quite confused with the behaviour I'm seeing here. Any guidance is
appreciated.

Thanks

David
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to