Unicode quote characters parsing in FTS5 queries
David Guillen Fandos <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users