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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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 Cloud

Introducing Confluence Cloud for Microsoft Teams (Available for Preview!)

Hi Atlassian Community, Remote work has shifted how teams collaborate, and we’ve heard from many of you that Microsoft Teams has become mission critical to many of your workflows, from how you chat...

2,537 views 21 21
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