Escape single quote character for use in an SQLite query
Try doubling up the single quotes (many databases expect it that way), so it would be : INSERT INTO table_name (field1, field2) VALUES (123, ‘Hello there”s’); Relevant quote from the documentation: A string constant is formed by enclosing the string in single quotes (‘). A single quote within the string can be encoded by putting … Read more