title: Encoding issue on SQL Server
body: <p>I'm working with SQL Server database; database instance encoding is "SQL_Latin1_General_CP1_CI_AS".</p>
  
  <p>The following code:</p>
  
  <pre><code>UPDATE ...
  SET field = CHAR(136)
  WHERE...
  </code></pre>
  
  <p>puts in field the following symbol: ˆ </p>
  
  <p>But! In Latin1 code table 127-159 codes are just not defined! How comes it inserts this symbol?</p>
  
  <p>And what's more confusing, when I read this field value to string variable in C# and convert it to char, I get the code 710 instead of 136.</p>
  
  <p>I tried to use encoding conversion:</p>
  
  <pre><code>var latin1Encoding = Encoding.GetEncoding("iso-8859-1");
  var test = latin1Encoding.GetBytes(field); // field is a string read from db
  </code></pre>
  
  <p>But in this case I get code 94 which is ^ (looks similar, but it's not the same, and I need exactly same).</p>