0

Please login or register to vote for this query.

(click on this box to dismiss)

Based upon query from http://sqladm.blogspot.com/2011/02/list-of-collations.html

Q&A about the site for software quality control experts, automation engineers, and software testers

SELECT
 [name] 
 ,COLLATIONPROPERTY([name], 'CodePage') AS [CodePage]
 ,COLLATIONPROPERTY([name], 'LCID') AS [LCID]
 ,COLLATIONPROPERTY([name], 'ComparisonStyle') AS [ComparisonStyle]
 ,COLLATIONPROPERTY([name], 'Version') AS [Version]
 ,[description]
FROM ::fn_helpcollations()
ORDER BY 4,1

view current version

edited jan 18 12

created jan 18 12 Mark Hurd