数据库字符集修改:
1、mysql配置文件修改:my.cnf修改,
[client]下增加:
default-character-set = utf8mb4
[mysqld]下增加:
init-connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
[mysql]下增加:
default-character-set = utf8mb4
修改后重启。
linux下重启命令:service mysql restart
window下先停止再启动:net stop mysql,net start mysql
2、修改database 的字符集:
执行sql:alter database zhongqidb_gem character set utf8mb4;
修改character_set_results 字符集:
SET character_set_results=utf8mb4;
执行sql:
ALTER TABLE t_member_details CHARSET=utf8mb4 COMMENT='用户详情表';
ALTER TABLE t_member_details MODIFY COLUMN personal_signature varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '个性签名';
4、项目中更改mysql的驱动jar:
改为:mysql-connector-java-5.1.39-bin.jar
5、项目中数据库配置文件:
<property name="url" value="${jdbc.url}?autoReconnect=true&autoReconnectForPools=true&initialTimeout=5&characterEncoding=UTF-8" />
去掉characterEncoding=UTF-8:
<property name="url" value="${jdbc.url}?autoReconnect=true&autoReconnectForPools=true&initialTimeout=5" />
1、mysql配置文件修改:my.cnf修改,
[client]下增加:
default-character-set = utf8mb4
[mysqld]下增加:
init-connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
[mysql]下增加:
default-character-set = utf8mb4
修改后重启。
linux下重启命令:service mysql restart
window下先停止再启动:net stop mysql,net start mysql
2、修改database 的字符集:
执行sql:alter database zhongqidb_gem character set utf8mb4;
修改character_set_results 字符集:
SET character_set_results=utf8mb4;
修改后执行sql查询是否已经成功修改:show variables like '%char%';
执行sql:
ALTER TABLE t_member_details CHARSET=utf8mb4 COMMENT='用户详情表';
ALTER TABLE t_member_details MODIFY COLUMN personal_signature varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '个性签名';
4、项目中更改mysql的驱动jar:
改为:mysql-connector-java-5.1.39-bin.jar
5、项目中数据库配置文件:
<property name="url" value="${jdbc.url}?autoReconnect=true&autoReconnectForPools=true&initialTimeout=5&characterEncoding=UTF-8" />
去掉characterEncoding=UTF-8:
<property name="url" value="${jdbc.url}?autoReconnect=true&autoReconnectForPools=true&initialTimeout=5" />