title: Why is sql server storing question mark characters instead of Japanese characters in NVarchar fields?
body: <p>I'm trying to store Japanese characters in nvarchar fields in my SQL Server 2000 database.</p>
  
  <p>When I run an update statement like:</p>
  
  <pre><code>update blah 
  set address = N'スタンダードチャ'
  where key_ID = 1
  </code></pre>
  
  <p>from SQL Server Management Studio, then run a select statement I see only question marks returned to the results window.  I'm seeing the same question marks in the webpage which looks at the database.</p>
  
  <p>It seems this is an issue with storing the proper data right?  Can anyone tell me what I need to do differently?</p>