UTF8 does not work for turkish characters

eemrecinar February 19, 2018

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. charactertest.png

2 answers

1 accepted

1 vote
Answer accepted
eemrecinar February 19, 2018

Hey Diego, 

First of all, thanks for the quick response. I tried countless encoding and collation changes but I have found the solution in this post:

https://stackoverflow.com/questions/21092007/why-java-strings-are-not-saved-as-utf-8-in-mysql

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.

GMK
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 19, 2018

For postgreSQL database use query:

show LC_CTYPE;
show LC_COLLATE

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.

0 votes
Diego
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 19, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events