title: Inserting Superscript Numbers in MS SQL
body: <p>Trying to insert a value into a <code>varchar</code> data field with the Superscript number of 4 (power of 4) at the end.  </p>
  
  <p>I'm able to insert/update values using superscript 2 and 3 (ie squared and cubed), but I can't get the power of 4 to enter correctly into a <code>varchar</code> field?</p>
  
  <p>It does work if I switch the field to a <code>nvarchar</code>, but I'm trying to avoid that.</p>
  
  <p>This works for squared or to the power of 2</p>
  
  <pre><code>update mytable
  set myfield = 'test'+NCHAR(0xb2)
  </code></pre>
  
  <p>However, trying to get this to work using a 4 at the end...</p>
  
  <pre><code>update mytable
  set myfield = 'test'+NCHAR(0x2074)
  </code></pre>
  
  <p>It just updates it a numeric 4 and not superscript 4. Is this because the <code>VarChar</code> datatype recognizes squared and cubed, but not any other ones?  </p>