Changing MDB or column collation for Catalog

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

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


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?

Applies to CA Service Catalog

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.