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
