title: How to store non english unicode characters using dynamic query in SQL Server
body: <p>I want to save non-english unicode characters into a table in SQL Server.</p>
  
  <pre><code>declare @cSql varchar(200)
  set @cSql = ''
  
  declare @cCode varchar(10)
  set @cCode = '001'
  
  declare @cKName Nvarchar(200)
  set @cKName = N'ಒಂದು'
  
  Insert into DepMast (omCode, omKName)
  Values(@cCode, @cKName)
  </code></pre>
  
  <p>On executing the above code, the unicode characters are saved as required.</p>
  
  <p>But, if I use dynamic query, <code>'?????'</code> is stored.</p>
  
  <pre><code>set @cSql = 'Insert into DepMast (omCode, omKName)
               Values(''' + @cCode + ''',''' + @cKName + ''')'
  
  exec(@cSql)
  </code></pre>
  
  <p>Any ideas on storing unicode characters using dynamic query?</p>