How to find the Character encoding of Confluence from the Database.
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This document will help you to find the Character Encoding from the Database.
Diagnosis
Confluence character encoding can be viewed and changed from the UI . This has been explained in Confluence Character Encoding. However, sometimes we need to know where it is stored in DB.
Solution
The Default character encoding is saved in Bandana table in Confluence Database. To fetch the encoding, we can run the below query
select Bandanavalue from bandana where bandanakey='atlassian.confluence.settings'
and bandanavalue like '%defaultEncoding%'
The result set will be a xml block where you can find the Character encoding under <defaultEncoding> element. You can find other system settings as well in the XML result set.
<settings>
<defaultEncoding>UTF-8</defaultEncoding>
<maxThumbHeight>300</maxThumbHeight>
<maxThumbWidth>300</maxThumbWidth>
<backupAttachmentsDaily>true</backupAttachmentsDaily>
</settings>As per the result above, the Character encoding of my Confluence instance is UTF-8.