一.数据库编码和字段编码为utf-8
show variables like '%character%';
ALTER TABLE biz_power_plan DEFAULT CHARACTER SET utf8;
ALTER TABLE biz_power_plan CHANGE cust_name cust_name VARCHAR(500) CHARACTER SET utf8;
二.linux服务器编码设置
1.查看当前语言包
echo $LANG
2.安装语言包
yum -y groupinstall chinese-support
3.查看所有语言包
locale -a
4.修改配置文件 /etc/sysconfig/i18n centos7为 /etc/locale.conf
LANG="zh_CN.UTF-8" SYSFONT="latarcyrheb-sun16" SUPPORTED="zh_CN.UTF-8:zh_CN:zh"