MySQL编码问题

错误显示：

Caused by: java.sql.BatchUpdateException: Incorrect string value: ‘\xE7\x9B\x91\xE8\xA7\x86…’ for column ‘ase_param1’ at row 1

1. 登陆数据库，查看默认编码格式

mysql -uroot -p

use database 数据库名;

SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "数据库名";

2. 修改编码

ALTER DATABASE 数据库名 CHARACTER SET utf8 COLLATE utf8_general_ci;

再次进行查看修改结果：

3. 查看更详细信息

show variables like"character_set_%";

4. 查看具体表的编码

SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = "数据库名" AND T.table_name = "表名";

至此，修改成功！