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

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

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.

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

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 Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 (you can also ...

2,483 views 14 20
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you