title: Norwegian character sorting wrongly in sql order by
body: <p>I just want to sort LastName column in Ent table.</p>
  
  <pre><code>select distinct LastName from Ent
  order by LastName desc
  </code></pre>
  
  <p>result set contains some Norwegian characters(Å,ø)</p>
  
  <p><img src="https://i.stack.imgur.com/3fRjq.png" alt="enter image description here"></p>
  
  <p>DB and related column collation is 'Danish_Norwegian_CI_AS'</p>
  
  <p>my issue is it's showing 'Aabakken'(which id = 141) 'Aaa'(which id = 142) and 'Aa' (which id = 143) in here.I believe those are in English letters and should be shown in last of the results..</p>
  
  <p>why those values showing there and how can I fix it.</p>
  
  <p>please help me.. thanks</p>