| title | sys.fn_helpcollations (Transact-SQL) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 06/10/2016 | |||
| ms.prod | sql-non-specified | |||
| ms.reviewer | ||||
| ms.suite | ||||
| ms.technology |
|
|||
| ms.tgt_pltfrm | ||||
| ms.topic | language-reference | |||
| f1_keywords |
|
|||
| dev_langs |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | b5082e81-1fee-4e2c-b567-5412eaee41c1 | |||
| caps.latest.revision | 38 | |||
| author | BYHAM | |||
| ms.author | rickbyh | |||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-asdb-asdw-pdw-_md]
Returns a list of all supported collations.
Transact-SQL Syntax Conventions
fn_helpcollations ()
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.
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';
[!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)