On 14 Nov 2013, at 12:58pm, L. Wood <lwoo...@live.com> wrote:
> Suppose I have a table with one text column. I insert like this:
>
> INSERT INTO my_table (col1) VALUES ('arbitrary UTF-8 string');
>
> * Isn't it true that the string must indeed be surrounded by single quotes as
> I do above?
> * Isn't it true that I have to replace all occurrences of ' in the original
> string with '' (to escape each single quote)?
> * Do I have to do anything else at all?
In addition to the other responses to your questions, if you do choose to
supply the whole command as an executable string, then the answers to your
questions are yes, yes and no.
If you want a way to test SQL command I advise you to download and use the
SQLite shell tool:
<http://www.sqlite.org/sqlite.html>
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
