Skip to content
This repository was archived by the owner on Apr 20, 2019. It is now read-only.

Commit fe498f9

Browse files
authored
Update collation-functions-collationproperty-transact-sql.md
Text revisions to tighten and optimize the reading flow of the material.
1 parent f3aa02a commit fe498f9

1 file changed

Lines changed: 7 additions & 7 deletions

File tree

docs/t-sql/functions/collation-functions-collationproperty-transact-sql.md

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest |
3131
# Collation Functions - COLLATIONPROPERTY (Transact-SQL)
3232
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
3333

34-
Returns the property of a specified collation in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].
34+
This function returns the property of a specified collation in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].
3535

3636
![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
3737

@@ -43,17 +43,17 @@ COLLATIONPROPERTY( collation_name , property )
4343

4444
## Arguments
4545
*collation_name*
46-
Is the name of the collation. *collation_name* is **nvarchar(128)**, and has no default.
46+
The name of the collation. The *collation_name* argument has an **nvarchar(128)** data type, with no default value.
4747

4848
*property*
49-
Is the property of the collation. *property* is **varchar(128)**, and can be any one of the following values:
49+
The collation property. The *property* argument has a **varchar(128)** data type, and can have any one of the following values:
5050

5151
|Property name|Description|
5252
|---|---|
53-
|**CodePage**|Non-Unicode code page of the collation. Please see [Appendix G DBCS/Unicode Mapping Tables](https://msdn.microsoft.com/en-us/library/cc194886.aspx) and [Appendix H Code Pages](https://msdn.microsoft.com/en-us/library/cc195051.aspx) to translate these values and see their character mappings.|
54-
|**LCID**|Windows LCID of the collation. Please see [LCID Structure](https://msdn.microsoft.com/en-us/library/cc233968.aspx) to translate these values (you will need to convert to **varbinary** first).|
55-
|**ComparisonStyle**|Windows comparison style of the collation. Returns 0 for all binary collations, both (\_BIN) and (\_BIN2), as well as when all properties are sensitive. Bitmask values:<br /><br /> Ignore case : 1<br /><br /> Ignore accent : 2<br /><br /> Ignore Kana : 65536<br /><br /> Ignore width : 131072<br /><br /> Note: Even though it affects the comparison behavior, the variation-selector-sensitive (\_VSS) option is not represented in this value.|
56-
|**Version**|The version of the collation, derived from the version field of the collation ID. Returns an integer value between 0 and 3.<br /><br /> Collations with "140" in the name return 3.<br /><br /> Collations with "100" in the name return 2.<br /><br /> Collations with "90" in the name return 1.<br /><br /> All other collations return 0.|
53+
|**CodePage**|Non-Unicode code page of the collation. See [Appendix G DBCS/Unicode Mapping Tables](https://msdn.microsoft.com/en-us/library/cc194886.aspx) and [Appendix H Code Pages](https://msdn.microsoft.com/en-us/library/cc195051.aspx) to translate these values, and tosee their character mappings.|
54+
|**LCID**|Windows LCID of the collation. See [LCID Structure](https://msdn.microsoft.com/en-us/library/cc233968.aspx) to translate these values (you will first need to convert to **varbinary**).|
55+
|**ComparisonStyle**|Windows comparison style of the collation. Returns 0 for all binary collations - both (\_BIN) and (\_BIN2) - as well as when all properties are case sensitive. Bitmask values:<br /><br /> Ignore case : 1<br /><br /> Ignore accent : 2<br /><br /> Ignore Kana : 65536<br /><br /> Ignore width : 131072<br /><br /> Note: the variation-selector-sensitive (\_VSS) option is not represented in this value, even though it affects the comparison behavior.|
56+
|**Version**|The version of the collation, derived from the collation ID version field. Returns an integer value between 0 and 3.<br /><br /> Collations with "140" in the name return 3.<br /><br /> Collations with "100" in the name return 2.<br /><br /> Collations with "90" in the name return 1.<br /><br /> All other collations return 0.|
5757

5858
## Return types
5959
**sql_variant**

0 commit comments

Comments
 (0)