Issue
What SQL collation does Security Expert use?
Product Line
EcoStruxure Security Expert
Environment
- Security Expert server
- Microsoft SQL Server
Cause
Need to know the SQL collation used in Security Expert databases.
Resolution
The default collation is SQL_Latin1_General_CP1_CI_AS. This is the only supported collation and is set by default during installation and creation of the Security Expert databases.
Changing the collation can have serious ramifications to the stability and operation of Security Expert and is not supported.