title: Python psycopg2 not in utf-8
body: <p>I use Python to connect to my postgresql data base like this:</p>
  
  <pre><code>conn=psycopg2.connect(database="fedour", user="fedpur", password="***", host="127.0.0.1", port="5432")
  </code></pre>
  
  <p>No problem for that.</p>
  
  <p>But when I make a query and I want to print the cursor I have something like this:</p>
  
  <p>"Fran\xc3\xa7ois" instead of "François" and it cause problem when I want to create a XML document with this. 
  I thkink is come from my encodage, but I found any solution. I try to encode('utf-8') but doesn't work.</p>
  
  <p>I have also seen something like this, but its only for mySQL</p>
  
  <pre><code>MySQLdb.connect(charset='utf8', init_command='SET NAMES UTF8')
  </code></pre>
  
  <p>Can you help me ? Thanks</p>