Variant Order 2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tom Thomson » Variant Order 2

27 posts, Page 1 of 3

1 2 3 »»»

Variant Order 2

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Saturday, December 03, 2011 2:37 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 PM
Points: 7,088, Visits: 7,143

Comments posted to this topic are about the item Variant Order 2

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1215891

bitbucket-25253

Posted Saturday, December 03, 2011 3:00 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:16 PM
Points: 5,101, Visits: 20,201

Nice question

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1215894

Stewart "Arturius" Campbell

Posted Monday, December 05, 2011 1:25 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

Good question, with well constructed explanation.
Thanks, Tom

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1216094

440692 I am just a number

Posted Monday, December 05, 2011 1:47 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:12 AM
Points: 1,631, Visits: 2,028

Thank you
A very interesting question.
Alas, I could see no other way to work out the answer, than to run the code.

Post #1216103

Pieter de K

Posted Monday, December 05, 2011 2:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 14, 2013 2:25 AM
Points: 124, Visits: 139

wrong post. my mistake...

Post #1216120

rfr.ferrari

Posted Monday, December 05, 2011 3:00 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219, Visits: 13,507

very good question, Tom!!!

thanks!

rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!

Post #1216132

Koen Verbeeck

Posted Monday, December 05, 2011 3:41 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

Nice question, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1216147

palotaiarpad

Posted Monday, December 05, 2011 4:07 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 846, Visits: 321

Nice question, good explanation. If i will ever have use of it, i don't know. Wink

Post #1216161

L' Eomot Inversé

Posted Monday, December 05, 2011 4:16 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 PM
Points: 7,088, Visits: 7,143

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)

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1216169

michael.kaufmann

Posted Monday, December 05, 2011 5:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 11:51 PM
Points: 1,263, Visits: 1,079

Thanks for a very interesting question.

Got it right by a wrong assumption Smile

Figured that Latin1_General_100_CI_AS will always be the "first" and prevailing collation (and hence picked the only option having "C" as the first character).
After answering, when running and playing with the code, I found that my assumption was wrong, because if the collations included e.g. Arabic_100_CI_AS, Czech_100_CI_AS or Danish_Greenlandic_100_CI_AS, the result(s) would have been different.

You may find the following pages helpful for digging deeper into the matter:
Collation Settings--check out the SQL LCID column (since noted in hex, any value lesser than 0x0409 will be listed before Latin1_General_100_CI_AS);
Collation Names--which will list the most recent collation names (with the _100 designator in the name) along with the older equivalents (as used on the previously mentioned page; unless the collation got introduced with SQL 2008).

Post #1216212

« Prev Topic | Next Topic »

27 posts, Page 1 of 3

1 2 3 »»»

Permissions