• Hugo Kornelis (6/19/2013)


    sqlnaive (6/19/2013)


    In a normal scenario it should be considered as the default behaviour for the question which is CI (and not CS).

    I disagree, and I'll tell you why.

    In questions where collation is not a factor, using the consistent case throughout the question prevents ambiguity. If you ensure the question works okay onm a CS collation, it will also be okay on a CI collation. The reverse is not true. So writing the question for a CS collation is the best way to ensure that everyone has a fair chacne - including those who are aware that not all SQL Server instances in the world are installed on a CI collation.

    And in questions where collation is a factor, the collation should always be included in the question, so there can never be a problem there.

    Although I agree that it is probably a good idea to specify the collation when it is relevant (i.e. when it affects the answer to the question) I also have my doubts about it. After all, case-sensitive collations are an absolute pain for almost all purposes, so it might be a good idea to get people whose servers are set up with case-sensitive collations to suffer a little extra pain in QOTD in the hope that this might encourage them not to use the horrible things in the future. :hehe::w00t::hehe:

    Tom