title: ORACLE - NLS_LANG, CHARSET, SPECIAL CHARS
body: <p>I have the following problem on WINDOWS (Italian):</p>
  
  <p><a href="https://i.stack.imgur.com/4CVHn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4CVHn.png" alt="ORACLE DB NLS_PARAMETERS"></a></p>
  
  <p>my NLS_LANG parameter is: <strong><em>ITALIAN_ITALY.UTF8</em></strong></p>
  
  <p>i want to execute the following query:</p>
  
  <pre><code>INSERT INTO SCHEMA.MY_TABLE("NAME") VALUES('ò');
  </code></pre>
  
  <p>Doing it by using command line (pure sqlplus) stores invalid data inside DB.</p>
  
  <p>Doing it by using SQLDEVELOPER stores correct data.</p>
  
  <p>I cannot find any way to set this stuff correctly, what should I do? Using SQLPLUS from command line is <strong>required</strong>.</p>
  
  <p>Any help is appreciated.</p>