title: SQL server SORT order does not correspond to ASCII code order
body: <p>I'm using SQL Server 2012, and I have a database with a <code>SQL_Latin1_General_CP1_CI_AS</code> collation: </p>
  
  <pre><code>create table testtable (c nvarchar(1) null)
  
  insert into testtable (c) values('8')
  insert into testtable (c) values('9')
  insert into testtable (c) values(':')
  insert into testtable (c) values(';')
  
  select c, ASCII(c) ascvalue 
  from testtable 
  order by c
  </code></pre>
  
  <p>I get this output:</p>
  
  <pre><code>c | ascvalue
  ------------
  : | 58
  ; | 59
  8 | 56
  9 | 57
  </code></pre>
  
  <p>Why does SQL Server sort the order contrary to ascii code order?</p>