title: Unicode sql query in cx_Oracle
body: <p>i have the following: </p>
  
  <pre><code>ora_wet = oracle_connection()
  cursor = ora_wet.cursor()
  sqlQuery = u"SELECT * FROM web_cities WHERE cty_name = 'София'"
  cursor.execute(sqlQuery)
  sqlResult = cursor.fetchone()
  </code></pre>
  
  <p>When I do this I get the following error:</p>
  
  <pre><code>TypeError: expecting None or a string on line 18 which is the cursor.execute(sqlQuery)
  </code></pre>
  
  <p>If I make the query non-unicode (without the u) it goes through but it returns nothing</p>
  
  <p>edit: in reply to first comment:</p>
  
  <p>NLS_LANGUAGE is BULGARIAN,</p>
  
  <p>NLS_CHARACTERSET is CL8MSWIN1251</p>
  
  <p>language is Python...</p>
  
  <p>yes there is a record with cty_name = 'София'</p>
  
  <p>connection is just:</p>
  
  <pre><code>def oracle_connection():
      return cx_Oracle.connect('user/pass@server')
  
  ora_wet = oracle_connection()
  </code></pre>