title: Add N' Character Before Insert statement SQL Server 2005
body: <p>I have a problem that needing help, please give me an advice.
  I want to insert database from one Oracle Server to SQL server by statements as:</p>
  
  <pre><code>SELECT * INTO ABC_temp SELECT * FROM DIM_PROVINCE
  </code></pre>
  
  <p>In DIM_PROVINCE and ABC_temp  have 3 columns: <code>PROVINCE_ID</code>, <code>PROVINCE_NAME</code> and <code>NOTE</code>
  The problem is It can not shows VietNamese Language. After I searched on the internet for helping, everybody shows that I must use N’ character before INSERT statement.
  So, how can I replace this statement.</p>
  
  <pre><code>INSERT INTO ABC_temp values (N’abc,N’abc,N’abc)
  </code></pre>
  
  <p>By statement bellows:</p>
  
  <pre><code>SELECT * INTO ABC_temp SELECT * FROM DIM_PROVINCE
  </code></pre>
  
  <p>Thank You!</p>