Skip to content

sys-fn-helpcollations-transact-sql.md

Latest commit

 

History

History
81 lines (62 loc) · 3.52 KB

sys-fn-helpcollations-transact-sql.md

File metadata and controls

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

sys.fn_helpcollations (Transact-SQL)

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

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