title: How to properly insert some special characters like trademark to Oracle database
body: <p>I have an Oracle database. I have to execute some insert scripts that fill a nvarchar2 column. The insert statements include some special characters like “(left quote), ”(right quote), ™(trademark sign). </p>
  
  <pre><code>create table myTable ( column1 number, column2 nvarchar2(50) );
  insert into myTable (column1, column2) values(1, 'Lorem Ipsum™ Sed “dolor sit amet”');
  </code></pre>
  
  <p>I run the query on SQLDeveloper Editor. But special characters replace with question marks as below:</p>
  
  <pre><code>select * from myTable;
  
  Column1     Column2
  ------      ------------------------------
  1           Lorem Ipsum? Sed ?dolor sit amet?
  </code></pre>
  
  <p>But when I add a new line to table with SQLDeveloper GUI it's just fine <a href="https://i.stack.imgur.com/0FOL1.jpg" rel="nofollow noreferrer">like this image</a></p>
  
  <p>Database NLS parameters is here:</p>
  
  <pre><code>SELECT * FROM NLS_DATABASE_PARAMETERS where PARAMETER in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');
  
  PARAMETER               VALUE
  ------------            ------------
  NLS_CHARACTERSET        WE8ISO8859P9
  NLS_NCHAR_CHARACTERSET  AL16UTF16
  </code></pre>
  
  <p>What should I do for inserting the characters I mentioned above properly?</p>