Changing MDB or column collation for Catalog

Document ID : KB000011803
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

This document is intended to answer queries around MDB collation and collation at columns level for Catalog tables

Question:

Is changing the collation of MDB and some tables where the collation is specifically set on columns after initial install is supported for Catalog? What impact would this have on future upgrades, patches etc?

Environment:
Applies to CA Service Catalog
Answer:

Catalog search, other areas of the application and CABI reports are heavily depending on the collation at table level and column level. So as of now we do not support the collation changes in usm_xxx table (related to catalog). As a result, changing the collation of the MDB for Catalog will lead some unexpected behavior.