SQL Collation support in BizTalk360

A collation is a configuration setting that determines how the database engine should treat character data at the server, database, table or column level. SQL Server includes a large set of collations for handling the language and regional differences, there are about 3887 collations. In which the CI refers to Case Insensitive CS refers to Case Sensitive.
Few lists of SQL collation are,

• SQL_Latin1_General_CS_AS
• SQL_Latin1_General_CI_AI
• Finnish_Swedish_CS_AS
• Finnish_Swedish_CI_AI
• French_100_CI_AS_WS_SC

Most of our customers configure BizTalk360 in the SQL Server instance where BizTalk Server is configured. BizTalk Server supports all case sensitive and case insensitive SQL Server collations except for binary collations. So, it is important that BizTalk360 should support the same collations.
BizTalk360 can be configured as following

• BizTalkMgmtDb (Latin1_General_CS_AS) & BizTalk360 (Latin1_General_CI_AI)

• BizTalkMgmtDb (Latin1_General_CS_AS) & BizTalk360 (Latin1_General_CS_AS)

• SQL Server (Latin1_General_CS_AS) & BizTalk360 Database (Latin1_General_CI_AI)

• SQL Server (Latin1_General_CS_AS) & BizTalk360 Database (Latin1_General_CS_AS)

If you change the default collation of a database, each new table you create in that database will use that collation. Since BizTalk360 supports many features like ESB, BAM, Azure etc. When having case sensitive collation for BizTalk360 Database, it is important that we look into all the sections of BizTalk360 (Operation, Monitoring, Analytics and Settings) to make it work efficiently. Through which BizTalk360 version 9.0.2 is efficient enough to handle both case sensitive and case insensitive collation.