CollationName Element (ADF)
Specifies the collation of the database, which determines the languages it supports and the sort order in which query results are returned.
Syntax
<Database>
...
<CollationName>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string, between 1 and 255 characters in length. |
Default value |
The default collation of the Microsoft SQL Server instance. |
Occurrence |
Optional once per Database element. |
Updates |
Cannot be added, deleted, or modified when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
The CollationName element defines the character set and sort order for the application database. The CollationName value must conform to the SQL Server nvarchar data type and must be the name of a valid Windows or SQL Server collation.
If you do not provide a CollationName value, the application database collation is the same as the default collation of the Database Engine instance that hosts the database.
Note
You must exclude the CollationName element if you do not specify a collation value.
The CollationName value of all application databases in a SQL Server Notification Services instance must match the collation of the instance database.
For more information about collations, see COLLATE (Transact-SQL).
Example
The following example shows a CollationName element set to a SQL Server collation. The collation uses the Latin1 General dictionary sorting rules, code page 437 (United States English), and uses binary sort order.
<CollationName>SQL_Latin1_General_Cp437_BIN</CollationName>
The following example shows a CollationName element set to the Latin1 General dictionary sorting rules, Windows code page 1252. This collation is case-insensitive and accent-sensitive.
<CollationName>Latin_General_CI_AS</CollationName>
See Also
Reference
Application Definition File Reference
Other Resources
COLLATE (Transact-SQL)
Defining the Application Database