Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

What is the collation type supported in confluence

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

1 answer

0 votes
Fadoua Community Leader Feb 25, 2021

@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

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 Community Leader Feb 26, 2021

@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

@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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...

1,407 views 7 29
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you