数据库与服务器编码设置

一.数据库编码和字段编码为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"