Freigeben über


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

Database Element (ADF)

Child elements

None.

Hinweise

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.

ms145356.note(de-de,SQL.90).gifHinweis:
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).

Beispiel

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>

Siehe auch

Verweis

Application Definition File Reference

Andere Ressourcen

COLLATE (Transact-SQL)
Definieren der Anwendungsdatenbank

Hilfe und Informationen

Informationsquellen für SQL Server 2005