L' Eomot Inversé (12/5/2011)

---

That's startling. I don't have a modern (windows 7 or later) platform available to test on, but given that all the locales ids are different there should be no imaginable way for a new locale version to affect the order of these collations; the only thing I can thionk of is that some locale ids have been changed.

It would be useful if you could run the following code and post the results here, so that we can see what has happened in Denali to make this order change.

select cname CollationName, collationproperty(cname,'LCID') LCID 
  from (values('bosnian_latin_100_ci_as'),
              ('corsican_100_ci_as'),
              ('latin1_general_100_ci_as'),
              ('norwegian_100_ci_as'),
              ('romansh_100_ci_as')
       ) X(cname)

Ninja's_RGR'us (12/5/2011)

---

He edited out his comment.

I've run the same thing on Denali CTP3 and it returns the same results as sql 2008 R2.

L' Eomot Inversé (12/5/2011)

---

Thanks for the good news, Remi; I was quite wondering what on earth could be going on, and it's nice to know that it was nothing.

Rob Schripsema (12/5/2011)

---

Great question. Not what I would have expected....but then, many aspects of SQLVariants are not what I would expect.