Поделиться через


CollationName Element (ICF)

Specifies the collation of the database, which determines how SQL Server sorts and compares data.

Синтаксис

<Database>
    ...
    <CollationName>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 255 characters in length.

Default value

None.

Occurrence

Optional once per Database element.

Updates

Cannot be modified.

Element Relationships

Relationship Elements

Parent element

Database Element (ICF)

Child elements

None.

Замечания

If using a collation different from the default collation for the instance of SQL Server, specify the collation name using this element. The default is the collation setting of the model database.

All databases for an instance of Notification Services, including application databases, must use the same collation.

For more information about SQL Server collations and a list of possible collation values, see Имя параметров сортировки SQL (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

Основные понятия

Instance Configuration File Reference

Справка и поддержка

Получение помощи по SQL Server 2005