Changing MDB or column collation for Service Catalog

Products

• CA Service Catalog
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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 Service Catalog Catalog?

What impact would this have on future upgrades, patches etc?

Environment

Clarity Service Catalog 17.x

Resolution

Service Catalog search, other areas of the application and 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 Service Catalog).

As a result, changing the collation of the MDB for Service Catalog will lead some unexpected behavior.