I'm using confluence server 6.7 and installed it using UTF8. document content seems fine but I'm having problems in Space Name and Page Titles. Typing the character "Ş" but getting "?" instead. I tried few ways to overcome but none of them worked for me.
First of all, thanks for the quick response. I tried countless encoding and collation changes but I have found the solution in this post:
This is something mysql hides from you perfectly. I saw that some of my db variables are set to latin1. I double checked my .cnf files but some of these variables weren't included. So I added them in the .cnf file and the problem solved.
For the users having the same problem;
Please please please run this before you do anything:
mysql> SHOW VARIABLES LIKE 'char%';
all variables must be utf8. If not, set them first before going deeper.
For postgreSQL database use query:
to verify if utf-8 is used.
There are known issues related to upper-case special characters in attachment filenames when "C" collation is used with PostgreSQL -https://jira.atlassian.com/browse/CONFSERVER-54305
In addition to database collation/characterset I would recommend to check in application.xml configuration file if sun.jnu.encoding and file.encoding are pointing to utf-8 - see https://confluence.atlassian.com/confkb/filesystem-encoding-is-written-as-ansi_x3-4-1968-even-though-the-server-is-set-to-utf-8-658735809.html for more information and possible fix.
Hello Emre! Thank you for posting your issue here at the Community.
Looking at the results from your encoding test, you might have problems with your *database encoding*.
You may need to fix the collation of your database. You can check further information on how to do it here at https://confluence.atlassian.com/doc/configuring-database-character-encoding-177698.html .
(!) Be sure that Confluence is Down before applying changes to your database.
(!) (!) Always backup your database before applying any change to it
I attended Atlassian Summit 2019 and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...
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