Is it possible to apply your own collation to an MSSQL database hosting Control-M products?

Version 3
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Control-M/Enterprise Manager


    APPLIES TO:

    Control-M/Enterprise Manager



    QUESTION:

     
       Is it possible to apply your own collation to an MSSQL database hosting Control-M products  


    ANSWER:

     

    Legacy ID:KA326325

      

    Control-M/Enterprise Manager and Control-M/Server will create the databases with the collation "Latin1_General_BIN" regardless of the MSSQL Server's collation.

      

    This means the Control-M databases can be hosted on an MSSQL Server that uses a specific collation like SQL_Latin1_General_CP1_CI_AS.

      

    If this is problematic for any reason, please consult with BMC to discuss this further.

      
    Related Products:  
       
    1. Control-M/Enterprise Manager

     


    Article Number:

    000019204


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles