It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

UTF8 does not work for turkish characters

Emre ÇINAR Feb 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
Emre ÇINAR Feb 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.

Greg Kowalczyk Atlassian Team Feb 19, 2018 • edited

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 Rodrigues Atlassian Team Feb 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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

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

2,342 views 11 28
Read article

Community Events

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

Events near you