SQL Server 2008 is fully aligned with the collations in Windows Server 2008.
To this end, it has 80 new collations which are denoted by *_100 version references.
The total number of variations for these collations exceeds 1400.
The purpose of this enhancement is to provide users with the most up-to-date and linguistically accurate cultural sorting conventions.
In order to see the new collations along with their variations in SQL Server 2008 you can use the following T-SQL query:
--Get new collation details
SELECT [name], [description]
FROM sys.fn_helpcollations()
WHERE [name] LIKE '%100%'
For more information on SQL Server 2008 Collation and Unicode Support you can check out the following link.
Labels: SQL Server 2008