title: Parameter sql query not working with special quote like this ’
body: <p>Select statement:</p>
  
  <pre><code>self.selectSQLQuery = 'SELECT * FROM DIM WHERE REPORT_NAME=?'
  
  cur.execute(sqlQuery,trans)
  </code></pre>
  
  <p>I am using a parameterized query and there are some single quotes in the string and there is this character/string which is not working property</p>
  
  <pre><code>Cantons De L’est
  </code></pre>
  
  <p>When I print the list of parameter it looks correct for <code>'</code></p>
  
  <pre><code>("St. John's",)
  ("St. John's",)
  ('Edmonton',)
  ('Victoria',)
  ('Cantons De L’est',)
  </code></pre>
  
  <p>Any solution for this other than replace it to <code>'</code></p>