Collation in Service Manager


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


 


Comments (0)

Skip to main content