Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Strange 'order by' - can anyone explain ? RE: Strange 'order by' - can anyone explain ?
HanShi
SSC-Dedicated
Points: 33506
More actions
August 28, 2013 at 4:31 am
#1645475
If I apply the "Danish_Norwegian_CS_AS" collation to the query it does indeed sort BB-CC-AA. So yes, the collation does matter.
I don't know why, but perhaps that's because I'm not Danish ;-).