Incorrect string value: '\xE6\x9C\xB1\xE6\xB1\x9F' for column '姓名' at row 1

问题中的错误是在数据库操作过程中出现的，错误信息是"在第1行的'姓名'列中，'\xE6\x9C\xB1\xE6\xB1\x9F'的字符串值不正确"。根据引用，这个错误可能是由于name列的字符集不是UTF-8而是latin1所导致的。解决这个问题的方法是将字符集更改为UTF-8。你可以通过更改数据库表的字符集或者修改相关配置文件中的字符集设置来解决这个问题。<span class="em">1</span><span class="em">2</span>
#### 引用[.reference_title]
- *1* [MySql插入数据时出现：Incorrect string value: ‘\xE6\x9F\xB3\xE5\xB2\xA9...‘ for column ‘name‘ at ...](https://blog.csdn.net/weixin_54514751/article/details/127916855)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [MySql 错误Incorrect string value for column](https://download.csdn.net/download/weixin_38631331/13694558)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]