September 11, 2012 at 8:17 pm
Comments posted to this topic are about the item CS Collation
September 11, 2012 at 8:19 pm
Thanks -- Nice question an addition thank you for the extra information in the explanation of the correct answer ...
September 11, 2012 at 11:45 pm
Avocado 😀
September 12, 2012 at 1:07 am
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
September 12, 2012 at 1:29 am
Really good question. thanks
September 12, 2012 at 1:41 am
I had expected uppercase to sort before lower because of the ASCII values.
Its useful to get these things cleared up.
September 12, 2012 at 2:24 am
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 🙂
September 12, 2012 at 2:27 am
Nice question, I got the answer right however I was not sure about the case ordering so thanks for the explanation.
September 12, 2012 at 4:03 am
Nice one, 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 12, 2012 at 4:20 am
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.
September 12, 2012 at 5:02 am
Great question. Thanks.
September 12, 2012 at 5:09 am
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.
September 12, 2012 at 5:32 am
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.
September 12, 2012 at 5:46 am
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'?
September 12, 2012 at 6:02 am
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?
Viewing 15 posts - 1 through 15 (of 45 total)
You must be logged in to reply to this topic. Login to reply