How to escape double quote in string in SQLite query?
The SQL standard specifies that single-quotes in strings are escaped by putting two single quotes in a row. SQL works like the Pascal programming language in the regard. SQLite follows this standard.
It works for double quotes also.
INSERT INTO TABLENAME VALUES("WHAT""S THAT")INSERT INTO TABLENAME VALUES("WHAT''S THAT")read this How do I use a string literal that contains an embedded single-quote (') character