Escape single quote character for use in an SQLite query

by

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 two single quotes in a row – as in Pascal. C-style escapes using the backslash character are not supported because they are not standard SQL. BLOB literals are string literals containing hexadecimal data and preceded by a single “x” or “X” character. … A literal value can also be the token “NULL”.

More Related Contents:

  1. How do I rename a column in a SQLite database table?
  2. How do I check in SQLite whether a table exists?
  3. Accessing an SQLite Database in Swift
  4. How to delete or add column in SQLITE?
  5. Import CSV to SQLite
  6. Select random row from a sqlite table
  7. How to get Top 5 records in SqLite?
  8. Insert new column into table in sqlite?
  9. How do you enable LIMIT for DELETE in SQLite?
  10. Sqlite primary key on multiple columns
  11. SQLite Schema Information Metadata
  12. How to create custom functions in SQLite
  13. SQLite: How do I save the result of a query as a CSV file?
  14. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  15. How to generate all dates between two dates
  16. SQLITE_BUSY The database file is locked (database is locked) in wicket
  17. Does it matter what extension is used for SQLite database files?
  18. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  19. How do I DROP a constraint from a sqlite (3.6.21) table?
  20. Sqlite over a network share [closed]
  21. How do I add a new column in between two columns?
  22. SQLite table constraint – unique on multiple columns
  23. Is there a boolean literal in SQLite?
  24. Case sensitive and insensitive like in SQLite
  25. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  26. SQLite for large data sets?
  27. sql query – how to apply limit within group by
  28. SQLite database supporting Unicode data
  29. Creating stored procedure in SQLite
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment