title: How to handle unicode data in cx_Oracle and python 2.7?
body: <p>I am using</p>
  <pre><code>Python 2.7
  cx_Oracle 6.0.2
  </code></pre>
  <p>I am doing something like this in my code</p>
  <pre><code>import cx_Oracle
  connection_string = &quot;%s:%s/%s&quot; % (&quot;192.168.8.168&quot;, &quot;1521&quot;, &quot;xe&quot;)
  connection = cx_Oracle.connect(&quot;system&quot;, &quot;oracle&quot;, connection_string)
  cur = connection.cursor()
  print &quot;Connection Version: {}&quot;.format(connection.version)
  query = &quot;select *from product_information&quot;
  cur.execute(query)
  result = cur.fetchone()
  print result
  </code></pre>
  <p>I got the output like this</p>
  <blockquote>
  <p>Connection Version: 11.2.0.2.0</p>
  <p>(1, u'????????????', 'test')</p>
  </blockquote>
  <p>I am using following query to create table in oracle database</p>
  <pre><code>CREATE TABLE product_information 
      ( product_id          NUMBER(6) 
      , product_name        NVARCHAR2(100) 
      , product_description VARCHAR2(1000));
  </code></pre>
  <p>I used the following query to insert data</p>
  <pre><code>insert into product_information values(2, 'दुःख', 'teting');
  </code></pre>
  <p><strong>Edit 1</strong></p>
  <p>Query: <code>SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');</code></p>
  <p>Result</p>
  <blockquote>
  <p>NLS_LANGUAGE: AMERICAN, NLS_TERRITORY: AMERICA, NLS_CHARACTERSET:
  AL32UTF8</p>
  </blockquote>