fn_helpcollations (Transact-SQL)
Returns a list of all the collations supported by SQL Server 2008.
Transact-SQL Syntax Conventions
| Note |
|---|
Deprecated collations that are no longer supported or installed in SQL Server 2008 cannot be queried with fn_helpcollations. |
The following example returns all collation names starting with the letter L and that are binary sort collations.
USE AdventureWorks; SELECT Name, Description FROM fn_helpcollations() WHERE name like 'L%' AND description LIKE '% binary sort';
Here is the result set.
Name Description ------------------- ------------------------------------ Latin1_General_BIN Latin1-General, binary sort Latvian_BIN Latvian, binary sort Lithuanian_BIN Lithuanian, binary sort Lithuanian_Classic_BIN Lithuanian-Classic, binary sort (4 row(s) affected)
