title: Special character not showing up in select query in SQL Server
body: <p>I have an question about special characters not showing up in the query </p>
  
  <pre><code>DECLARE  @varName1 NVARCHAR(500); 
  set  @varName1 = 'ÜCŞKUçÖ'
  select '''' + @varName1 + ''' As Name1'
  </code></pre>
  
  <p>These are the Turkish characters. When I run the above query I get this character as <code>S</code> but it should come as <code>Ş</code></p>
  
  <p>In the database I have this column value as  <code>ÜCŞKUçÖ</code></p>
  
  <p>How can I solve the issue? </p>