infinidb默认是latin字符集,而我们一般用utf-8字符集,因此需要调整;
[root@RTB_IOP_MYSQL ~]# vim /usr/local/Calpont/mysql/my.cnf
添加如下内容:
[client]
#password = your_password
port = 3306
socket = /usr/local/Calpont/mysql/lib/mysql/mysql.sock
default-character-set =utf8
在[mysqld]下添加:
character-set-server =utf8
collation-server =utf8_general_ci
init-connect ='SET NAMES utf8'
[root@RTB_IOP_MYSQL etc]# vim /usr/local/Calpont/etc/Calpont.xml
修改如下内容:
<SystemConfig>
<SystemLang>en_US.utf8</SystemLang>
<SystemName>calpont-1</SystemName>
<ParentOAMModuleName>pm1</ParentOAMModuleName>
<StandbyOAMModuleName>unassigned</StandbyOAMModuleName>