Collation, Unicode & Joins

Question

Collation, Unicode & Joins

Viewing 10 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 1

Sean Pearce (7/23/2014)
Igor Micev (7/23/2014)
Question is good, but why would someone use a join with different collations?
Simply to test ones knowledge of string comparison in a fun question, nothing more.

😎 then. Thanks again.

Igor Micev,My blog: www.igormicev.com

Toreador SSChampion Points: 11358 More actions · Answer 2

Sean Pearce (7/23/2014)Some Documentation

Yes very good.

Now, how about some actual documentation (from Microsoft), rather than some forum and blog posts that don't actually address the question but just assume the answer?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

TomThomson (7/23/2014)
Good question (but a pity about the unwanted editing).

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

Toreador (7/23/2014)
Sean Pearce (7/23/2014)Some Documentation
Yes very good.
Now, how about some actual documentation (from Microsoft), rather than some forum and blog posts that don't actually address the question but just assume the answer?

I'm just having some fun, don't get cross.

I don't think it is documented at all, but is generally well known.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Most interesting question - thanks, Sean!

I am just a bit skeptical that 58 percent of people got this right without running it...

edit: typo

Toreador SSChampion Points: 11358 More actions · Answer 6

Sean Pearce (7/23/2014)
I'm just having some fun, don't get cross.

sorry there was meant to be a smiley in there 😛

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

Revenant (7/23/2014)
...
I am just a bit skeptical that 58 percent of people got this right without running it...

😀 Definitely I am not one of them; even though I had my assumptions right without proper basement, I still executed the code to make sure what this is going to do, and later I became more interested in actual-EP.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 8

Great question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

Nice question, thx 😀

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

Raghavendra Mudugal (7/24/2014)
Revenant (7/23/2014)
...
I am just a bit skeptical that 58 percent of people got this right without running it...
😀 Definitely I am not one of them; even though I had my assumptions right without proper basement, I still executed the code to make sure what this is going to do, and later I became more interested in actual-EP.

+ 1 😉

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant