CS Collation

  • Comments posted to this topic are about the item CS Collation

  • 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]

  • Avocado 😀

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

  • Really good question. thanks

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

    Its useful to get these things cleared up.

  • 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 🙂

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

  • This was removed by the editor as SPAM

  • Nice one, 🙂

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

  • 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.

  • Great question. Thanks.

  • 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.

  • 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.

  • 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