Jira and Confluence on SQL Server

Question

I'm installing Confluence 6.9 with MS-SQL Server. The documentation say make default collation for the database to SQL_Latin1_General_CP1_CS_AS (case sensitive).

I'm also installing Jira Server 7.9 with MS-SQL Server. The install documentation says "Make sure the collation type is case-insensitive."

How will they work together?

I need Jira & Confluence linked via Weblinks, will this conflict?

Charlie Misonne · Answer

Hi Regg

On your database server you should create 2 databases. One for each application with a different collation.

For the procedures check https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2014-938846861.html and https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html

Brant Schroeder · Answer

The database collation will not impact and application link.  All of the traffic that takes place between the applications is done using the api so everything will work as expected. It is important to configure the DB correctly or you will see errors or performance issues.