Share via

Collation in Service Manager

  • Article

Service Manager doesn't like the default collation method (SQL_Latin1_General_CP1_CI_AS). If your SCSM SQL server is running with that collation mode you will get a warning when you install SCSM.

Caution

If you continue Setup using the default collation (SQL_Latin1_General_CP1_CI_AS), you will not be able to support multiple languages in Service Manager. In the future, if you decide you want to support multiple languages, you will have to re-install SQL Server.

The collations in the following table represent the approved collations that were tested.

 

Windows Locale

LCID

Collation

English

0x409

Latin1_General_100_CI_AS

Chinese_Taiwan

0x404

Chinese_Traditional_Stroke_Count_100_CI_AS

Chinese_PRC

0x804

Chinese_Simplifies_Pinyin_100_CI_AS

French

0x40C

French_100_CI_AS

German_Standard

0x407

Latin1_General_100_CI_AS

Italian_Standard

0x410

Latin1_General_100_CI_AS

Japanese

0x411

Japanese_XJIS_100_CI_AS

Korean

0x412

Korean_100_CI_AS

Portuguese_Brazilian

0x416

Latin1_General_100_CI_AS

Russian

0x419

Cyrillic_General_100_CI_AS

Spanish_Modern_Sort

0xC0A

Modern_Spanish_100_CI_AS