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

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

Zak, thank you for the reply, 

I've done all of it

mysql> SHOW VARIABLES LIKE 'character\_set\_%';
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+--------+
7 rows in set (0.00 sec)

You can see config mysql  here

I've done all of SQL request for Fix the Collation and Character Set

And I changed Java 10 to java 8

Also I've done test

But until nothing has changed and I have ????????????

What can I do else?

[Regan Gill]

Did you get this solved? 

[Andrey Ozerov]

Try to add in setenv.sh:

CATALINA_OPTS="-Dsun.jnu.encoding=UTF-8 -Dfile.encoding=UTF-8 -Dencoding=UTF-8 ${CATALINA_OPTS}"