title: SQL Server 2012 not showing unicode character in results
body: <p>All I want to do is update a field with the <a href="http://www.fileformat.info/info/unicode/char/2393/index.htm" rel="noreferrer">DIRECT CURRENT SYMBOL FORM TWO</a> <code>⎓</code> character into my SQL Server 2012 database. Is that too much to ask? Apparently it is.</p>
  
  <p>The answer to <a href="https://stackoverflow.com/q/11342380/1439748">this question</a> and <a href="https://stackoverflow.com/q/1350968/1439748">this question</a> <em>is the same</em> and did not work for me.</p>
  
  <p>My update script</p>
  
  <pre><code>UPDATE Table 
  SET Value = N'SUPPLY 9-30Vdc 0.2W ⎓' 
  WHERE id = '1234'
  </code></pre>
  
  <p>Aaaaand the relevant table schema:</p>
  
  <pre><code>CREATE TABLE [dbo].[Table]
  (
      ...
      ... 
      [Value] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
      ...
      ...
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  </code></pre>
  
  <p>Want more? Here's the results of <code>sp_columns</code>:</p>
  
  <p><a href="https://i.stack.imgur.com/DTCAf.png" rel="noreferrer"><img src="https://i.stack.imgur.com/DTCAf.png" alt="enter image description here"></a></p>
  
  <p>Yes, I prefixed the string with N''. That should work, right? Nope. </p>
  
  <p>Screenshot:</p>
  
  <p><a href="https://i.stack.imgur.com/auIsJ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/auIsJ.png" alt="enter image description here"></a></p>
  
  <p>Notice the little box where the unicode character should be. Why, though?</p>