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

---

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

---

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

---

Pieter de K (12/5/2011)

---

Interesting... When I run the example on my SQL Server (Denali, CTP 3) the result is: A,D,B,E,C

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)

He edited out his comment.

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

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.