How put specifical characters in sqlite3
Solution 1:
You should parameterize your SQL, otherwise you're vulnerable to SQL injection. Imagine if someone's name contained valid SQL statements: you would end up executing that, which could be bad.
statement = "INSERT INTO users VALUES (?, ?, ?)"
values = (a, b, c)
cur.execute(statement, values)
This will properly escape the values into the executed SQL statement.