<CollationName> Element
SQL Server 2000
Specifies the collation of the database, which determines the languages it supports and the sort order in which query results are returned.
Structure
<Database> ... <CollationName>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data Type | string, between 1 and 255 characters in length. |
| Default Value | The default collation of the SQL Server instance. |
| Occurrence | Optional once per <Database> node. |
| Updates | Cannot be added, deleted, or modified. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent Node | <Database> Node |
Remarks
The <CollationName> value must conform to the SQL Server nvarchar data type. It also must be the name of a valid Windows or SQL Server collation.