CS Collation

  • Rich Weissler

    Hall of Fame

    Points: 3286

    Comments posted to this topic are about the item CS Collation

  • Ron McCullough

    SSC Guru

    Points: 63877

    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: 150442

    Avocado 😀

  • vk-kirov

    SSCertifiable

    Points: 7686

    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: 6008

    Really good question. thanks

  • t.brown 89142

    SSCommitted

    Points: 1530

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

    Its useful to get these things cleared up.

  • Toreador

    SSChampion

    Points: 11261

    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

    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

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    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

    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.

  • (Bob Brown)

    SSCrazy

    Points: 2705

    Great question. Thanks.

  • (Bob Brown)

    SSCrazy

    Points: 2705

    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

    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

    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