SQL Server Collation Name (Transact-SQL)
Is a single string that specifies the collation name for a SQL Server collation.
SQL Server supports Windows collations. SQL Server also supports a limited number (<80) of collations called SQL Server collations which were developed before SQL Server supported Windows collations. SQL Server collations are still supported for backward compatibility, but should not be used for new development work. For more information about Windows collations, see Windows Collation Name (Transact-SQL).
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
To list the SQL Server collations supported by your server, execute the following query.
SELECT * FROM sys.fn_helpcollations() WHERE name LIKE 'SQL%';
1For Sort Order ID 80, use any of the Window collations with the code page of 1250, and binary order. For example: Albanian_BIN, Croatian_BIN, Czech_BIN, Romanian_BIN, Slovak_BIN, Slovenian_BIN.