title: How to handle special characters in the string while updating a table using python
body: <p>Im trying to update some rows to a table, in one of the row a string is having few special charecters. I should be updating the string as is to the db.</p>
  <p>I have this string &quot;<strong>CÃƒÂ´TE'R</strong>&quot; in one of the column of a df.</p>
  <p>To handle single quote (') i added one more quote like ('') which was worked, but it is not the case with '<strong>´</strong>'</p>
  <pre><code>query = &quot;update mytable set Name ='CÃƒÂ´TE''R' where id=1&quot;
  </code></pre>
  <p>Error:</p>
  <pre><code>cursor.execute(query)
  cx_Oracle.DatabaseError: ORA-00933: SQL command not properly ended
  </code></pre>
  <p>The same query works perfectly well when i run it in sqldeveloper.</p>
  <p>I should be updating these strings to db as is. I couldn't able to solve this. Could anyone please help me out? Thanks!!</p>