IBM Support

Database collation settings for Microsoft SQL Server

Question & Answer


Question

Are there any special database collation settings required when deploying with Microsoft SQL Server?

Answer

Microsoft SQL Server database collation settings must be set to the following options:

* Dictionary order
* Case-insensitive
* For use with 1252 Character set

Only the collation settings for the database are required to be updated.

[{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.2.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.2.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21509584