初次使用Confluence时,发现中文有问号,解决办法:
1.在mysql中输入以下命令:
mysql> show variables like 'char%';
|Variable_name | Value
+--------------------------+----------------
|character_set_client | gbk
|character_set_connection | gbk
|character_set_database | latin1
|character_set_filesystem | binary
|character_set_results | gbk
|character_set_server | latin1
|character_set_system | utf8
|character_sets_dir | C:/Program File
+--------------------------+----------------
8 rows in set (0.00 sec)
2.要latin1换成UTF-8的编码,就可以了,修改mysql的配置文件my.cnf,在/etc/my.cnf,加上下面三行
[root@localhost /]#vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disablingsymbolic-links is recommended to prevent assorted security risks
symbolic-links=0
collation_server=utf8_unicode_ci
character_set_server=utf8
skip-character-set-client-handshake
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
3.重启mysql中文显示正常了
systemctl restart mysqld