Skip to content

Latest commit

 

History

History
81 lines (63 loc) · 3.65 KB

File metadata and controls

81 lines (63 loc) · 3.65 KB
title sys.fn_helpcollations (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 08/23/2017
ms.prod sql
ms.prod_service database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology system-objects
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
author rothja
ms.author jroth
monikerRange >=aps-pdw-2016|| = azure-sqldw-latest ||=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.fn_helpcollations (Transact-SQL)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]

Returns a list of all supported collations.

Topic link icon 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 SQL Data Warehouse 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)
Database collation support for Azure SQL Data Warehouse