SQL SERVER - COLLATE
Arguments
Is the name of the collation to be applied to the database definition. The
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 '
The following table lists the supported Windows collation names. Ensure that the locale is supported on the device that the database is created.
No comments:
Post a Comment