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.

語法

<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	Database Element (ADF)
Child elements	None.

備註

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.

附註：
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).

範例

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>

請參閱

參考

Application Definition File Reference

其他資源

COLLATE (Transact-SQL)
定義應用程式資料庫

說明及資訊

取得 SQL Server 2005 協助