mysql 编码问题 Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value:

错误信息

Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xE6\x88\x91\xE4\xBB\xAC...' for column 'content' at row 1
 

这个问题的原因是因为字符集的编码问题导致ide

1. 查看字符集

登陆mysql

mysql -u root -p

 登陆之后输入

show variables like '%character%';

显示信息

 

mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | latin1