Collation Settings in Setup

Use the Collation Settings screen to modify default collation settings. Use the Windows Locale option to match collation settings in instances of Microsoft® SQL Server™ 2000. Use SQL Collations to match settings that are compatible with the sort orders in earlier versions of SQL Server.

Windows Locale

Change the default settings for Windows Locale (Windows collation) 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.

Collation Designator

Select the name of a specific Windows collation from the list, 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 Windows Collation Designators.

Sort Order

Select Sort Order options 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 Windows Collation Sorting Styles.

SQL Collations

The SQL Collations option is used for compatibility with earlier versions of Microsoft 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 SQL Collations.