Need additional character support for confluence (Japanese and Cyrillic characters:)

[Lakshman]

Hi team,

I need additional character support for Confluence to display characters such as boxes and arrows. It seems that the issue can be resolved as per the following link for Japanese and Cyrillic characters:

https://confluence.atlassian.com/confkb/characters-appear-as-question-marks-using-mysql-204051027.html

Note : Our Confluence is running on MS SQL Server 2012, but in the above link explains how to set the Character set in MYSQL database. Please provide the instructions

1. how I can update the Character set values for MS SQL Server 2012? 

2. If I change the Character set value in existing database, it will cause any issues.

Note : For your information, I found that my Confluence default SQL Server Collation is " SQL_Latin1_General_CP1_CI_AS”,

[Sloan]

Hi @Lakshman

The Collation needs to be SQL_Latin1_General_CP1_CS_AS (case sensitive). So it should be ok.

Make sure your Database is set up according to https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html

If you still have issues try this Knowledgebase article: https://confluence.atlassian.com/confkb/chinese-characters-appears-as-question-marks-776649333.html (It is about Chinese letters but it should be the same issue with Cyrillic)

Best Regards
Niklas