You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Apr 20, 2019. It is now read-only.
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)].
35
35
36
36
[Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
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.
47
47
48
48
*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:
50
50
51
51
|Property name|Description|
52
52
|---|---|
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.|
0 commit comments