SQL SERVER - COLLATE

SQL SERVER - COLLATE

Arguments


Is the name of the collation to be applied to the database definition. The argument can be only a specified .


Is the collation name for Windows collation. For a list of Windows collation names supported in Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile), see the "Remarks" section later in this topic.

CollationDesignator
Specifies the base collation rules used by the Windows collation. The base collation rules cover the following:

An alphabet or language whose sorting rules are applied when dictionary sorting is specified.


A code page used to store non-Unicode character data.


For example, Latin1_General and French are collation designators that use code page 1252. Turkish is a collation designator that uses code page 1254.

CaseSensitivity 
Specifies case-insensitive (CI). SQL Server Mobile supports this option only.

AccentSensitivity 
Specifies accent-sensitive (AS). SQL Server Mobile supports this option only.

All databases that are created without specifying the Windows collation name are assigned Latin1_General, the default collation. Example: Latin1_General_CI_AS. This collation uses the Latin1 General dictionary sorting rules, code page 1252. It is case-insensitive and accent-sensitive.

Use the optional COLLATE clause to specify a collation different from the default. For example, to specify a Spanish collation, use a query such as:

Copy Code
CREATE DATABASE "SpanishDB.sdf" DATABASEPASSWORD '' COLLATE Traditional_Spanish_CI_AS 

The following table lists the supported Windows collation names. Ensure that the locale is supported on the device that the database is created.