Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul White » Collation and SQL_VARIANT
Add to briefcase
42 posts, Page 3 of 5
«««12345»»»

Collation and SQL_VARIANT Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
cfradenburg
Posted Tuesday, November 01, 2011 6:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:44 AM
Points: 1,555, Visits: 1,925
Rich Weissler (11/1/2011)
Only row 2 matches the explicit Latin1_General_CI_AS collation in the query.

I see one row. Which is the other one?


That's row number 2, not two rows.
Post #1198625
Mattrick
Posted Tuesday, November 01, 2011 6:51 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:26 AM
Points: 581, Visits: 693
Great question that made me think. Great explanation.

Thanks,

Matt
Post #1198633
L' Eomot Inversé
Posted Tuesday, November 01, 2011 7:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:38 PM
Points: 7,077, Visits: 7,116
SQL Kiwi (11/1/2011)
L' Eomot Inversé (11/1/2011)
Excellent question.

I wonder if there's another on sql_variant in the pipleline?

Not at this stage, at least not by me. I was going to do one based on the weird sort order of SQL_VARIANT, but it's too obtuse even for me

That's the very one I was wondering about, as it seems a natural next question (as you've defined a UNIQUE constraint on a variant column, there must be a total order on SQL_variant to produce the index that supports that constraint. It's not really all that obtuse, if I remember the ordering rules correctly. In fact I'm tempted to ask that one myself if you are not going to. Or even ask two or three questions on it (on second thoughts, maybe that I'm contemplating two or three questions means it is a bit obtuse).

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 #1198637
Rich Weissler
Posted Tuesday, November 01, 2011 7:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:15 AM
Points: 1,564, Visits: 768
cfradenburg (11/1/2011)That's row number 2, not two rows.

Doh! That's clear as day now. Thank you! (Both for the answer, and the patience.) (I learned two things today! First, a little more about SQL_Variant. Second, don't try to comprehend the QotD answer before coffee.)
Post #1198648
Cliff Jones
Posted Tuesday, November 01, 2011 7:41 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:11 PM
Points: 3,390, Visits: 3,403
Very interesting question.
Post #1198658
OzYbOi d(-_-)b
Posted Tuesday, November 01, 2011 8:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
Thanks Kiwi! Another great great question that had me looking more closely at something I hadn't yet tinkered with too much. Cheers mate!
Post #1198715
SQLRNNR
Posted Tuesday, November 01, 2011 9:08 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329
cool question


Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1198744
Stuart Davies
Posted Tuesday, November 01, 2011 9:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:19 AM
Points: 2,473, Visits: 2,131
Britt Cluff (11/1/2011)
Wow, did I have to think on this one. Thanks for the interesting question.


+ 1 - Thanks

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1198753
KWymore
Posted Tuesday, November 01, 2011 9:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:58 AM
Points: 2,570, Visits: 1,530
Interesting stuff, thanks!
Post #1198756
Iulian -207023
Posted Tuesday, November 01, 2011 9:49 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, March 16, 2013 9:53 AM
Points: 847, Visits: 768
Nice one, thanks

Iulian
Post #1198777
« Prev Topic | Next Topic »

Add to briefcase
42 posts, Page 3 of 5
«««12345»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.