How to escape special characters like ‘ in sqlite in android

by

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. Example:

INSERT INTO xyz VALUES('5 O''clock');

Ref : SQLite FAQ

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Hindi font not displying correctly in android [closed]
  3. Share SQLite database between 2 android apps?
  4. Location of sqlite database on the device
  5. Android: upgrading DB version and adding new table
  6. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  7. Deleting Row in SQLite in Android
  8. Best place to close database connection
  9. Store Android SQLite
  10. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  11. How to split comma-separated value in SQLite?
  12. How to write character & in android strings.xml
  13. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  14. Cursor adapter and sqlite example [closed]
  15. Android sqlite how to check if a record exists
  16. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  17. How to retrieve data from sqlite database in android and display it in TextView
  18. SQLite Exception no such column when trying to select
  19. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  20. Android: column ‘_id’ does not exist
  21. How can I insert image in a sqlite database
  22. Android Cursor with ORMLite to use in CursorAdapter
  23. Is it possible to apply primary key on the text fields in android database
  24. What is The use of moveToFirst () in SQLite Cursors
  25. How to store sqlite database directly on sdcard
  26. sqlite example program in android [closed]
  27. How to check database on not rooted android device
  28. How to store JSON object in SQLite database
  29. Android SQLiteOpenHelper cannot open database file
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment