MySQL表插入中文错误：ERROR 1366 (HY000): Incorrect string value: '\xE8\x87\xAA\xE5\x8A\xA8...'

插入语句

insert into ops_user(username,password,duties,age,gender,entry_time) values('beckham','123456','自动化运维','43','男','20190313');

错误信息

ERROR 1366 (HY000): Incorrect string value: '\xE8\x87\xAA\xE5\x8A\xA8...' for column 'duties' at row 1

原因数据库以及表再创建的时候默认为latin1字符集

查看数据库字符集语句

show create database devops;
+----------+-------------------------------------------------------------------+
| Database | Create Database                                                   |
+----------+-------------------------------------------------------------------+
| devops   | CREATE DATABASE `devops` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+-------------------------------------------------------------------+
1 row in set (0.00 sec)

修改默认字符集为utf8

alter database devops character set utf8;
Query OK, 1 row affected (0.00 sec)

show create database devops;
+----------+-----------------------------------------------------------------+
| Database | Create Database                                                 |
+----------+------------------