Home Forums Article Discussions Article Discussions by Author Discuss content posted by Paul White Collation and SQL_VARIANT RE: Collation and SQL_VARIANT

  • November 2, 2011 at 6:41 am

    #1402109

    Hugo Kornelis (11/2/2011)

    michael.kaufmann (11/2/2011)

    Hm, do you have an explanation why the following code will return the exact same result? :crazy:

    My guess would be that your server has a default collation of Latin1_General_CI_AS. My server has Latin1_General_CS_AS as the default, and when I run your code, I get the row with id=4 returned.

    Thanks for your quick reply, Hugo--tend to keep forgetting about the default server collation... :w00t: (I ran the test in tempdb, not in a user database with a known collation).