Collation order by

Question

Post reply

Collation order by

GeorgeCopeland

SSCertifiable

Points: 6997
More actions
January 17, 2018 at 11:40 pm

#334487

Comments posted to this topic are about the item Collation order by

Viewing 11 posts - 1 through 10 (of 10 total)

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

HappyGeek SSCoach Points: 18729 More actions · Answer 1

Good question that made me think, thanks George.

...

manik_anu SSCrazy Points: 2397 More actions · Answer 2

nice question. really i am confused about collation now... any one explain about collation

Manik
You cannot get to the top by sitting on your bottom.

Stewart "Arturius" Campbell SSC Guru Points: 72701 More actions · Answer 3

Nice question, thanks George
Really reitterates the detail differences in the way SQL Server handles the various collations

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

Carlo Romagnano SSC-Insane Points: 22737 More actions · Answer 4

Carlo Romagnano

SSC-Insane

Points: 22737

January 18, 2018 at 1:45 am

#1976281

It's surprising me!

Rune Bivrin SSCrazy Eights Points: 8583 More actions · Answer 5

I got it right. Collations are tricky business. I think this is one case where people from countries that don't use English as their primary language have an edge.

But the reference doesn't really explain anything; it makes no effort at detailing where SOH might fall in a sorting sequence.

Just because you're right doesn't mean everybody else is wrong.

ildjarn.is.dead Ten Centuries Points: 1167 More actions · Answer 6

ildjarn.is.dead

Ten Centuries

Points: 1167

January 18, 2018 at 2:10 am

#1976284

SQL 2015?

Rune Bivrin SSCrazy Eights Points: 8583 More actions · Answer 7

ildjarn.is.dead - Thursday, January 18, 2018 2:10 AM
SQL 2015?

It's a special release only Steve has

Just because you're right doesn't mean everybody else is wrong.

GeorgeCopeland SSCertifiable Points: 6997 More actions · Answer 8

GeorgeCopeland

SSCertifiable

Points: 6997

January 18, 2018 at 8:05 am

#1976333

Thank you for your kind comments, guys.

webrunner SSC-Dedicated Points: 31957 More actions · Answer 9

Here is a slight edit with the complete table variable declaration, just for fun.
Thanks for the great question!

declare @TableAsc table ( [Value] varchar(30) );

--Declare a table variable with a varchar column and insert the following values-- insert @TableAsc values (CHAR(65) + '-Uppercase A') ,(CHAR(1) + '-Start of header') ,(CHAR(126) + '-Tilde ~') ,(CHAR(32) + '-Space') ,(CHAR(45) + '-Dash');

SELECT * FROM @TableAsc ORDER BY Value COLLATE Latin1_General_CI_AS;

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

GeorgeCopeland SSCertifiable Points: 6997 More actions · Answer 10

You are quite welcome. This query shows the sort order for all ASCII characters and is a little more useful--

DECLARE @Asc INT = 0 DECLARE @TableAsc TABLE(AscVal INT, CharVal CHAR(1))

WHILE @Asc <= 127 BEGIN INSERT @TableAsc VALUES(@Asc, char(@Asc)) SET @Asc = @Asc + 1 END

SELECT * FROM @TableAsc ORDER BY CharVal COLLATE Latin1_General_CI_AS

Collation order by

Cookies on SQLServerCentral