title: How to insert data into NVARCHAR2 field with plsql developer?
body: <pre><code>Oracle version: 11gr2,
  NLS_CHARACTERSET: WE8MSWIN1252,
  NLS_NCHAR_CHARACTERSET: AL16UTF16,
  client NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252,
  PL/SQL Developer version: 8.0
  </code></pre>
  
  <p>I have a table which has a NVARCHAR2 field, I try to execute INSERT statement in <strong>PL/SQL Developer</strong> to insert some Chinese characters, but I cannot make it work. Below is the sql I use:<br></p>
  
  <pre><code>INSERT INTO charset_test VALUES(102,N'中');
  </code></pre>
  
  <p>But it works fine when using <strong>Oracle SQL Developer</strong> by just setting the option <code>convertNcharLiterals=true</code>. So I wonder if there is a similar option for <strong>PL/SQL Developer</strong> ?</p>
  
  <p>Thanks in advance.</p>