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


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/