Collation Element (ASSL)

Determines the collation used by the parent element.

Syntax

<Database> <!-- or one of the elements listed below in the Element Relationships table -->
   ...
   <Collation>...</Collation>
   ...
</Database>

Element Characteristics

Characteristic Description

Data type and length

String

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

Cube, Database, DataItem, Dimension, MiningModel, MiningStructure

Child elements

None

Remarks

The Collation string consists of the locale identifier (LCID) and the comparison flag, separated by an underscore character. For example, Latin1_General_CI_AS is an acceptable string.

The elements that correspond to the parents of Collation in the Analysis Management Objects (AMO) object model are Cube, Database, DataItem, Dimension, MiningModel, and MiningStructure.

See Also

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance