Chinese characters are not supported

Question

I used mysql database with charset utf8,

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

and changed server.xml like this:

url="jdbc:mysql://localhost:3306/knowage_ce?characterEncoding=utf-8"

But, When i saved Chinese characters , it not work ok.
Such as,menu manage page ,users manage page.

Pls. tell me what can I do?

Answer 1

I get it.

When I spended a day on complie and debug source code from github (knowage6.2.0-RC) ,I find code source quite correct  .

But,Knowage run ok in eclipse ,but have errors in out tomcat server  for Chinese characaters .

So, the problem only in tomcat server.

Result:

1.In Windows update $tomcat_path/bin/catalina.bat:

set JAVA_OPTS=%JAVA_OPTS% -Dfile.encoding=UTF-8

2.In Linux update $tomcat_path/bin/catalina.sh

JAVA_OPTS="-Dfile.encoding=UTF-8"

3. In Docker update Docker image entrypoint.sh

sed -i "s|#!\/bin\/sh|#!\/bin\/sh\nJAVA_OPTS=\"-Dfile.encoding=UTF-8\"|g" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/bin/catalina.sh

Comments

Hi, 

We have this problem with persian charecters too, and we asked this problem previously: 

"https://www.knowage-suite.com/qa/2759/problem-with-using-utf-persian-character-dataset-and-chart?show=2759#q2759 "

then we use your solution : 

1.In Windows update $tomcat_path/bin/catalina.bat:

set JAVA_OPTS=%JAVA_OPTS% -Dfile.encoding=UTF-8

but it doesn't work for us, can you help us please?

---

Make ure your database used UTF-8 frist.

Answer 2

We also encounter this problem, do not know how to solve it? They are all Chinese users. Let's exchange experiences. Killboos0314@gmail.com