Incorrect string value: ‘\\xB2\\xE9\\xD1\\xAF\\xCA\\xD3...‘ for column ‘name‘ at row 1

我是要在linux命令行中执行sql脚本新增语句报错的

报错明文如下：

在mysql配置文件中添加字符集后重启mysql就正常了

mysql -uroot -proot123 -e “SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%’ OR Variable_name LIKE ‘collation%’”

mysql -uroot -proot123 -e “SHOW VARIABLES LIKE ‘character%’”