Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Collation Settings (64-bit)

SQL Server 2000

  This topic applies only to SQL Server 2000 (64-bit).

Use the Collation Settings page of the Microsoft® SQL Server™ 2000 (64-bit) Installation Wizard to modify default collation settings that SQL Server uses for language and sorting purposes. Change the Collation designator option only if your installation of SQL Server must match the collation settings used by another instance of SQL Server 2000, or must match the Windows locale of another computer. Use the SQL Collations option to match settings that are compatible with the sort orders in earlier versions of SQL Server.

Options

Collation designator

Designates the collation to be used by this instance of SQL Server 2000. The default setting for this is the Microsoft Windows® locale setting for your computer (the Language for non-Unicode programs setting or the closest equivalent from the Regional and Language Options in Control Panel). Change the default settings for this and the sort order only if your installation of SQL Server must match the collation settings used by another instance of SQL Server 2000, or if it must match the Windows locale of another computer.

In the list, select the name of a specific Windows collation. For example:

  • Use Latin1_General for the U.S. English character set (code page 1252).

  • Use Modern_Spanish for all variations of Spanish, which also use the same character set as U.S. English (code page 1252).

  • Use Arabic for all variations of Arabic, which use the Arabic character set (code page 1256).

  • Use Japanese_Unicode for the Unicode version of Japanese (code page 932), which has a different sort order from Japanese, but the same code page (932).

    For more information, see the "Windows Collation Sorting Styles" topic in the SQL Server 2000 32-bit Books Online.

Sort order

Specifies the sort order to use with the Collation designator selected. Binary is the fastest sorting order and is case-sensitive. If Binary is selected, the Case-sensitive, Accent-sensitive, Kana-sensitive, and Width-sensitive options are not available. For more information, see the "Windows Collation Sorting Styles" topic in the SQL Server 2000 32-bit Books Online.

SQL Collations

The SQL Collations option is used for compatibility with earlier versions of SQL Server. Select this option to match settings compatible with SQL Server version 7.0, SQL Server version 6.5, or earlier. For more information, see the "Using SQL Collations" topic in the SQL Server 2000 32-bit Books Online.

For more information, see the "Specifying the Collation Setting" topic in the SQL Server 2000 32-bit Books Online.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.