Transact-SQL Syntax ConventionsThis function returns the property of a specified collation in SQL Server 2017
Transact-SQL Syntax Conventions
collation_name
The name of the collation. The collation_name argument has an nvarchar(128) data type, with no default value.
property
The collation property. The property argument has a varchar(128) data type, and can have any one of the following values:
| Property name | Description |
|---|---|
| CodePage | Non-Unicode code page of the collation. See Appendix G DBCS/Unicode Mapping Tables and Appendix H Code Pages to translate these values, and to see their character mappings. |
| LCID | Windows LCID of the collation. See LCID Structure to translate these values (you will first need to convert to varbinary). |
| 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: Ignore case : 1 Ignore accent : 2 Ignore Kana : 65536 Ignore width : 131072 Note: the variation-selector-sensitive (_VSS) option is not represented in this value, even though it affects the comparison behavior. |
| Version | The version of the collation, derived from the collation ID version field. Returns an integer value between 0 and 3. Collations with “140” in the name return 3. Collations with “100” in the name return 2. Collations with “90” in the name return 1. All other collations return 0. |
sql_variant
Here is the result set.
Azure SQL Data Warehouse and Azure SQL Data Warehouse Parallel Data Warehouse
Here is the result set.