sys-fn-helpcollations-transact-sql.md

title	sys.fn_helpcollations (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/23/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	fn_helpcollations fn_helpcollations_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.fn_helpcollations function collations [SQL Server], supported fn_helpcollations function
ms.assetid	b5082e81-1fee-4e2c-b567-5412eaee41c1
caps.latest.revision	38
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.fn_helpcollations (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-asdw-pdw-_md]

Returns a list of all supported collations.

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 which were developed before [!INCLUDEssNoVersion] supported Windows collations. [!INCLUDEssNoVersion] 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.

Examples

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';  

[!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)
Database collation support for Azure SQL Data Warehouse