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 for system and network administrators

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()
WHERE LOWER(name) LIKE '%port%'
ORDER BY 4,1

fork query

edited sep 27 13 LS_dev

created jan 18 12 Mark Hurd