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?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
