Transact-SQL Reference
COLLATIONPROPERTY
Returns the property of a given collation.
Syntax
COLLATIONPROPERTY( collation_name, property )
Arguments
collation_name
Is the name of the collation. collation_name is nvarchar(128), and has no default.
property
Is the property of the collation. property is varchar(128), and can be any of these values:
| Property name | Description |
|---|---|
| CodePage | The nonUnicode code page of the collation. |
| LCID | The Windows LCID of the collation. Returns NULL for SQL collations. |
| ComparisonStyle | The Windows comparison style of the collation. Returns NULL for binary or SQL collations. |
Return Types
sql_variant
Examples
SELECT COLLATIONPROPERTY('Traditional_Spanish_CS_AS_KS_WS', 'CodePage')
Result Set
1252