SQlite error while updating the table

Question

I am reading data from a table and updating into other table in SQLite. while reading it is not showing any error. But while it is updating it is showing error because the text i am going to update contains "You're" it is showing error for 're--> this apps' re. Any way to update with this special character?

roymustang86 · Accepted Answer · 2011-09-08 14:04:25Z

3

Insert another single quote after You' so that the text becomes "You''re"

http://sqlite.org/lang_expr.html

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.

answered Sep 8, 2011 at 14:04

roymustang86

8,74323 gold badges72 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQlite error while updating the table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related