> The apostrophes are escaped by apostrophes.
Correct. http://www.sqlite.org/faq.html#q14
> One more way you can do.
>
>insert into <table name> (<column name>) values ("*Goin' Down
> >> the Road Feelin' Bad*");
>
>It is double quotes before and after *. Similarly double quotes will
>be escaped by one more double quote
Don't do that: it can reveal a pitfall.
It's not SQL even if SQLite does its best to interpret it without
issuing an error.
Double quotes should be reserved to enclose database, table and column
names, not string literals. SQLite also accepts square brackets as
well: "My Table" is the same as [My Table].
Only use single quotes (apostrophes) for string literals.
A statement like:
delete from "my table" where column = "column";
is prone to disapoint you!
http://www.sqlite.org/faq.html#q24
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
