title: how to insert double byte to DB without add N into the literal
body: <p>a lot of people say you can do this:</p>
  
  <pre><code>declare @str        nvarchar(255);
  declare @finalValue nvarchar(255);
  
  set @str        = N'好使';
  set @finalValue = @str;
  </code></pre>
  
  <p>But this is not my case. What I want to do is something like this:</p>
  
  <pre><code>  declare @str        nvarchar(255);
    declare @finalValue nvarchar(255);
  
    set @str        = '好使'     ;
    set @finalValue = 'N'+ @str ;
  
    print @finalValue;
  </code></pre>
  
  <p>because the value <code>@str</code> actually is from somewhere else(CSV).</p>
  
  <p>In a stored procedure, I got the <code>@str</code> value from CSV and it is double byte (Chinese/Japanese), which is saved correctly) and I want to add <code>N</code> before inserting it in the DB table (without the <code>N</code>, it displays as <code>??</code> in the table.)</p>
  
  <p>How can I add the N?</p>