Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Variant Order 2 Expand / Collapse
Author
Message
Posted Saturday, December 3, 2011 2:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:21 PM
Points: 7,928, Visits: 9,653
Comments posted to this topic are about the item Variant Order 2

Tom
Post #1215891
Posted Saturday, December 3, 2011 3:00 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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
Posted Monday, December 5, 2011 1:25 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 4,158, Visits: 5,556
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
Posted Monday, December 5, 2011 1:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 12, 2014 12:44 AM
Points: 1,696, Visits: 2,139
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
Posted Monday, December 5, 2011 2:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 4:03 AM
Points: 144, Visits: 161
wrong post. my mistake...
Post #1216120
Posted Monday, December 5, 2011 3:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 18, 2014 2:55 AM
Points: 1,262, Visits: 13,558
very good question, Tom!!!

thanks!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1216132
Posted Monday, December 5, 2011 3:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
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
Posted Monday, December 5, 2011 4:07 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:44 AM
Points: 1,392, Visits: 516
Nice question, good explanation. If i will ever have use of it, i don't know.
Post #1216161
Posted Monday, December 5, 2011 4:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:21 PM
Points: 7,928, Visits: 9,653
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
Post #1216169
Posted Monday, December 5, 2011 5:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 11:12 PM
Points: 1,263, Visits: 1,081
Thanks for a very interesting question.

Got it right by a wrong assumption
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse