title: Oracle data insertion raising 'ascii' codec can't encode character '\xea' in position 87: ordinal not in range(128) error
body: <p>I am trying to insert <code>Portuguese</code> text into my table. But, it is giving <code>'ascii' codec can't encode character '\xea'</code> error.</p>
  
  <p>Here is what I am doing : </p>
  
  <pre><code>   os.environ["NLS_LANG"] = ".AL32UTF8"
  
     query = "INSERT INTO MESSAGE (MESSAGE,LANGUAGE) VALUES (:MESSAGE,:LANGUAGE)"
     data = {'MESSAGE': '..... assistência para ajuda responda AJUDA Sua', 'LANGUAGE': 'Portuguese'}
     cursor = conn.cursor()
     cursor.execute(query, data)
     .....
  </code></pre>
  
  <p>My table structure:</p>
  
  <pre><code>CREATE TABLE MESSAGE  (   
      language  VARCHAR2(12) NOT NULL, 
      message  NVARCHAR2(350) NOT NULL
  );
  </code></pre>
  
  <p>I am not sure if I need to set anything to insert other characters into the database.</p>