Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.fn_helpcollations (Transact-SQL)
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
SQL database in Microsoft Fabric
Returns a list of all supported collations.
👁 Image
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 |
SQL Server supports Windows collations. SQL Server also supports a limited number (<80) of collations called SQL Server collations, that were developed before SQL Server supported Windows collations. SQL Server 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';
Here's the result set.
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
Feedback
Was this page helpful?