sys-fn-helpcollations-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sys.fn_helpcollations (Transact-SQL)	sys.fn_helpcollations (Transact-SQL)	rwestMSFT	randolphwest	08/23/2017	sql	system-objects	reference	fn_helpcollations fn_helpcollations_TSQL	sys.fn_helpcollations function collations [SQL Server], supported fn_helpcollations function	TSQL	>=aps-pdw-2016|| = azure-sqldw-latest ||=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric

sys.fn_helpcollations (Transact-SQL)

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW FabricSE FabricDW]

Returns a list of all supported collations.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

fn_helpcollations ()  

Tables Returned

fn_helpcollations returns the following information.

Column name	Data type	Description
Name	sysname	Standard collation name
Description	nvarchar(1000)	Description of the collation

[!INCLUDEssNoVersion] supports Windows collations. [!INCLUDEssNoVersion] also supports a limited number (<80) of collations called [!INCLUDEssNoVersion] collations, that were developed before [!INCLUDEssNoVersion] supported Windows collations. [!INCLUDEssNoVersion] collations are still supported for backward compatibility, but shouldn't 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.

Examples

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

Note

Azure Synapse Analytics queries against fn_helpcollations() must be run in the master database.

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

[!INCLUDEssResult]

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)  

See Also

COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQL)
Collation and Unicode support