sys.fn_helpcollations (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns a list of all supported collations.

Topic link icon Transact-SQL Syntax Conventions

fn_helpcollations ()  

fn_helpcollations returns the following information.

Column nameData typeDescription
NamesysnameStandard collation name
Descriptionnvarchar(1000)Description of the 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). For more information about collations, see Collation and Unicode Support.

For Azure SQL Data Warehouse and Parallel Data Warehouse, you can only run this from the master database.

The following example returns all collation names starting with the letter L and that are binary sort collations.

SELECT Name, Description FROM fn_helpcollations()  
WHERE Name like 'L%' AND Description LIKE '% binary sort';  

Here is the result set.

Name Description

------------------- ------------------------------------

Lao_100_BIN Lao-100, binary sort

Latin1_General_BIN Latin1-General, binary sort

Latin1_General_100_BIN Latin1-General-100, binary sort

Latvian_BIN Latvian, binary sort

Latvian_100_BIN Latvian-100, binary sort

Lithuanian_BIN Lithuanian, binary sort

Lithuanian_100_BIN Lithuanian-100, binary sort

(7 row(s) affected)

COLLATE (Transact-SQL)

Community Additions