UTF8 does not work for turkish characters

[eemrecinar]

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. 

[eemrecinar · Accepted solution]

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]

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.

[Diego]

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