Why is does not sys.objects.type have the database default collation?

  • Today, I discovered to my big surprise that the type column of sys.objects is neither the default collation of the database nor the instance default collation, but it seems to always be Latin1_General_CI_AS_KS_WS. Does anyone know why this is so? The name column however, is following the database default collation.



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply