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 😀
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
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 2:28 am
This was removed by the editor as SPAM
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');
ID Veggie
1 p3pp3r
2 Pepp3rs
3 pepper
4 Pepper
5 PEPPER
6 peppers
7 Peppers
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'?
Viewing 15 posts - 1 through 15 (of 46 total)
You must be logged in to reply to this topic. Login to reply