On 11/29/2016 4:00 AM, Max Vlasov wrote:
I wonder why OP and other authors of the discussion
https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg49355.html
was so sure about backslash escaping support, even Igor Tandetnik :)
I said, and I quote:
"""
If you do it in your program, just put those characters in the query
string or
bound parameter string, using facilities of your programming language.
E.g. in
C that would be something like "trim(vEmail, ' \t\n')".
If you do it manually from, say, command line interface, you can do this:
update mytable set mycolumn=trim(mycolumn, cast(X'20090A' as text));
"""
That's the exact opposite of your interpretation. For backslash escapes,
you need to rely on "facilities of your programming language". If you
cannot, and must use raw SQL queries, there are still ways to represent
arbitrary characters, but backslash escapes is not one of them.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
