Re: Unicode quote characters parsing in FTS5 queries
Simon Slavin <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On 3 Feb 2020, at 9:30pm, David Guillen Fandos <[email protected]> wrote: > 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 At least one version of SQL respects those characters for quoting strings. Can't remember which one at the moment. I suspect that the problem you're encountering is intentional. One test you can try is to double that character (I'm typing the code, you type the character) 'abcU+2018U+2018def' and see whether this is still a syntax error, and whether you get zero, one or two of those characters in the output string. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users