how to solve problem with the encoding of Cyrillic characters

Сергей Акшенцев

Hi,
I've front problem with cyrillic characker in Confluence.
All of them is shown like this - "???". scrinshot 

My confluence version is 6.10, javac version 10.0.2

I'm use mysql and all confluence tables is in right encoding : utf_8 bin:

In my.conf I set up this params :

[mysqld]
init_connect='SET collation_connection = utf8_bin'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_bin
skip-character-set-client-handshake

I use tomcat, so in server.xml is set up :
<Connector port="8090" connectionTimeout="20000" redirectPort="8443"
maxThreads="48" minSpareThreads="10"
enableLookups="false" acceptCount="10" debug="0" URIEncoding="UTF-8"
protocol="org.apache.coyote.http11.Http11NioProtocol"
proxyName="31.25.242.24" proxyPort="80"/>

And, finally, in /var/atlassian/application-data/confluence/confluence.cfg.xml
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/conlf</property>

I'm changed this string to :
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/conlf?useUnicode=true&amp;characterEncoding=utf8</property>

But, no success. Please, help.

Zak Laughton

Hi Сергей,

A few more ideas of things to run through here for this:

• Run the following query from Characters appear as question marks using MySQL, and verify if there are any alternate character sets that may be overriding:
  

  SHOW VARIABLES LIKE 'character\_set\_%';

• Read through the Database setup for MySQL documentation, especially the modifications to the my.cnf file to be sure the collation is set up properly.
• Follow the steps on How to Fix the Collation and Character Set of a MySQL Database to diagnose and fix any lingering database encoding issues.
• Also, Confluence 6.10 does not support Java 10. While it's likely this issue is due to an encoding issue, it may also be worth trying a supported Java version to see if it fixes the issue.

Thanks!
-Zak