Skip to content

sql-server-collation-name-transact-sql.md

Latest commit

 

History

History
81 lines (60 loc) · 3.78 KB

sql-server-collation-name-transact-sql.md

File metadata and controls

81 lines (60 loc) · 3.78 KB
title SQL Server Collation Name (Transact-SQL)
description SQL Server Collation Name (Transact-SQL)
author WilliamDAssafMSFT
ms.author wiassaf
ms.date 02/21/2019
ms.service sql
ms.subservice t-sql
ms.topic reference
ms.custom
ignite-2025
helpviewer_keywords
collations [SQL Server], SQL collations
SQL collations
names [SQL Server], collations
dev_langs
TSQL
monikerRange >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb

SQL Server Collation Name (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]

Is a single string that specifies the collation name for a [!INCLUDEssNoVersion] 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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

<SQL_collation_name> :: =
SQL_SortRules[_Pref]_CPCodepage_<ComparisonStyle>

<ComparisonStyle> ::=
_CaseSensitivity_AccentSensitivity | _BIN

Arguments

SortRules A string identifying the alphabet or language whose sorting rules are applied when dictionary sorting is specified. Examples are Latin1_General or Polish.

Pref Specifies uppercase preference. Even if comparison is case-insensitive, the uppercase version of a letter sorts before the lowercase version, when there is no other distinction.

Codepage Specifies a one- to four-digit number that identifies the code page used by the collation. CP1 specifies code page 1252, for all other code pages the complete code page number is specified. For example, CP1251 specifies code page 1251 and CP850 specifies code page 850.

CaseSensitivity CI specifies case-insensitive, CS specifies case-sensitive.

AccentSensitivity AI specifies accent-insensitive, AS specifies accent-sensitive.

BIN Specifies the binary sort order to be used.

Remarks

To list the [!INCLUDEssNoVersion] collations supported by your server, execute the following query.

SELECT * FROM sys.fn_helpcollations()
WHERE name LIKE 'SQL%';

Note

For Sort Order ID 80, use any of the Window collations with the code page of 1250, and binary order. For example: Albanian_BIN, Croatian_BIN, Czech_BIN, Romanian_BIN, Slovak_BIN, Slovenian_BIN.

See Also