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
- TwitterConcatenating Row Values in Transact-SQL