Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize

COLLATIONPROPERTY

SQL Server 2000

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 

See Also

fn_helpcollations

Show:
© 2014 Microsoft