How do I confirm UTF-8 on MSSQL for JIRA and Confluence?

Question

Hi,

How do I confirm if the database is correctly setup for JIRA and Confluence.

In MSSQL 2005 , there is no option for UTF-8 in DATABASE_COLLATE.

Or, should i use LATIN for DB COLLATE?

I am really getting confused here about setting up UTF-8 for MSSQL.

Septa Cahyadiputra · Accepted Answer

Hi Lee,

In regards to collation for MS SQL server. The supported collation is SQL_Latin1_General_CP1_CS_AS, as describe on our documentation here.

Hope it helps.

Cheers,
Septa Cahyadiputra