Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Why is does not sys.objects.type have the database default collation? Expand / Collapse
Author
Message
Posted Monday, October 01, 2012 3:07 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, February 24, 2014 6:09 AM
Points: 827, Visits: 1,360
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
Post #1366406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse