CS Collation

Question

Post reply

CS Collation

Rich Weissler

Hall of Fame

Points: 3286
More actions
September 11, 2012 at 8:17 pm

#281434

Comments posted to this topic are about the item CS Collation

Viewing 15 posts - 1 through 15 (of 45 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Thanks -- Nice question an addition thank you for the extra information in the explanation of the correct answer ...

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

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Paul White SSC Guru Points: 150468 More actions · Answer 2

Avocado 😀

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

vk-kirov SSCertifiable Points: 7686 More actions · Answer 3

I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂

Arthur Olcot SSCertifiable Points: 6757 More actions · Answer 4

Arthur Olcot

SSCertifiable

Points: 6757

September 12, 2012 at 1:29 am

#1536582

Really good question. thanks

t.brown 89142 SSCommitted Points: 1530 More actions · Answer 5

I had expected uppercase to sort before lower because of the ASCII values.

Its useful to get these things cleared up.

Toreador SSChampion Points: 11382 More actions · Answer 6

None of the options gave the expected order, so it was obviously a question about the Latin1_General collation rather than case sensitivity.

Luckily I guessed right 🙂

Skanker Hall of Fame Points: 3059 More actions · Answer 7

Nice question, I got the answer right however I was not sure about the case ordering so thanks for the explanation.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

Nice one, 🙂

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

vk-kirov (9/12/2012)
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂

(to my knowledge)

Because here the "peppers" is plural. Of-course the number is always takes the first consideration

INSERT INTO #tbl_Avacado

VALUES ('Pepp3rs'),('Pepper'),('PEPPER'),('pepper'),('p3pp3r'),('peppers'),

('Peppers');

IDVeggie

1p3pp3r

2Pepp3rs

3pepper

4Pepper

5PEPPER

6peppers

7Peppers

Even 2 is plural and it contains number so the number gets sorted first and the 7 which is plural and it starts with caps so it is followed by the 6 in its ordinal position. Here also the weight of the word "pepper" will be less to the "peppers"

SELECT SOUNDEX ('pepper')

RESULT: 160

SELECT SOUNDEX ('peppers')

RESULT: 162

SELECT SOUNDEX ('p3pp3rs')

RESULT: 000

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

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 10

(Bob Brown)

SSCrazy

Points: 2705

September 12, 2012 at 5:02 am

#1536644

Great question. Thanks.

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 11

vk-kirov (9/12/2012)
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂

I don't get it either even with the prior explanation but it does sort that way.

vk-kirov SSCertifiable Points: 7686 More actions · Answer 12

Raghavendra Mudugal (9/12/2012)
vk-kirov (9/12/2012)
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
Because here the "peppers" is plural. Of-course the number is always takes the first consideration
...
Even 2 is plural and it contains number so the number gets sorted first and the 7 which is plural and it starts with caps so it is followed by the 6 in its ordinal position.

Well, I should note that nouns ending with the letter S are considered plural in English. But here we deal with a Latin collation, and the Romans had their Latin plural nouns ending with 'ae', 'i', 'ia', 'es' and other stuff :hehe:

If we substitute 'peppers' by 'pepperl', that 'pepperl' still will be in the end of the list... So I don't think that plural is the explanation.

Alex Fekken Ten Centuries Points: 1109 More actions · Answer 13

vk-kirov (9/12/2012)
Raghavendra Mudugal (9/12/2012)
vk-kirov (9/12/2012)
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
Because here the "peppers" is plural. Of-course the number is always takes the first consideration
...
Even 2 is plural and it contains number so the number gets sorted first and the 7 which is plural and it starts with caps so it is followed by the 6 in its ordinal position.
Well, I should note that nouns ending with the letter S are considered plural in English. But here we deal with a Latin collation, and the Romans had their Latin plural nouns ending with 'ae', 'i', 'ia', 'es' and other stuff :hehe:
If we substitute 'peppers' by 'pepperl', that 'pepperl' still will be in the end of the list... So I don't think that plural is the explanation.

I don't get it either: so 'feet' would come after 'foot'?

Toreador SSChampion Points: 11382 More actions · Answer 14

Alex Fekken (9/12/2012)
I don't get it either: so 'feet' would come after 'foot'?

That puzzled me as well, so I did some more testing and found that

"final" comes before "initial"

"eleven" comes before "ten"

"lots and lots" comes before "not many at all"

and

"bags" comes before "nowt"

Should this be reported to Microsft as a bug?