What is the collation type supported in confluence

[Jobin Jose]

What should be the SQL schema nad collation settings to be used while deplying confluence datacenter in Azure with Azure SQL DB.
The arm template says SQL_Latin1_General_CP1_CS_AS and dbo as schema.
but as per this link https://confluence.atlassian.com/confkb/connecting-confluence-applications-to-azure-sql-1038516401.html Collation types supported by Confluence are SQL_Latin1_General_CP437_CI_AI and Latin1_General_CI_AI

[Fadoua]

@Jobin Jose 

You follow what is suggested on the link you shared. Usually the steps are more than enough to get you everything working properly.

Here is a more general document about SQL DBs that may help as well:

https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html

Let me know if you have any questions 

Best,

Fadoua

[Jobin Jose]

Thank you Fadoua,

I tried both those collations with the ARM script for Azure but if I change it and deploy, the n confluence does not start. Do you know if this has to be done after creating the DB?

[Fadoua]

@Jobin Jose  The collation should be the very first step before you start the DB. Otherwise Confluence won't start.

You have to configure the DB before you connect Confluence to it.

Makes sense?

Best,

Fadoua

[Jobin Jose]

@Fadoua I think the arm scripts given here takes care of everything and we do not need to do anything specifically if we deploy using this. https://confluence.atlassian.com/confkb/connecting-confluence-applications-to-azure-sql-1038516401.html

However the value given inside this template does not match with the supported collation types given in the link I posted earlier. If I change it inside the template parameters to the ones mentioned in the document, then confluence does not start. So I just wanted to confirm if I have to stick to the value in teh ARM template or change it and deploy.