title: Unicode encode error: 'latin-1' in Python
body: <p>I am trying to program a script that retrieves XML data and then send them to my database, but I am having a problem encoding or decoding, I do not know. 
  I said that I searched the internet at earlier and try different things, but this does not solve my problem. This is why I turn to you to find a solution. </p>
  
  <p>Here's part of my code: </p>
  
  <pre><code># -*- coding: utf8 -*-
  ...
  REQ = u"INSERT INTO organismes (NAME_organisme,ID_organisme,ligne,cp,town,lat,lon,tel,fax,email,website) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);"
  cursor = db.cursor(MySQLdb.cursors.DictCursor)
  cursor.execute(REQ, (NAME,ID,LIGNE,CP,TOWN,LAT,LON,TEL,FAX,MAIL,URL))
  cursor.close()
  </code></pre>
  
  <p>Here is the error:</p>
  
  <pre><code>UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2019' in position 9: ordinal not in range(255)
  </code></pre>
  
  <p>I've tryed many exemple to encode this code in utf8. My Notepad++ encode "UTF-8 without DOM".</p>
  
  <p>Thx to answer me.</p>