1366 - Incorrect string value: '\xE6\xA8\xA1\xE5\x9D\x97' for column 'column_comment' at row 1
时间: 2023-09-12 21:03:54 浏览: 95
出现 "1366 - Incorrect string value" 的错误通常是由于数据库的字符集与插入的字符串不兼容导致的。根据引用的内容,可以尝试修改列的字符集和校对规则来解决这个问题。例如,你可以使用以下的SQL语句来修改列的字符集和校对规则:
```
ALTER TABLE saas_network.survey_shop_task MODIFY COLUMN column_comment varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
```
这个SQL语句将把 `column_comment` 列的字符集修改为 `utf8`,校对规则修改为 `utf8_general_ci`,请根据你的实际情况进行修改。这样修改后,再次插入包含特殊字符的字符串时就不会再出现 "1366 - Incorrect string value" 的错误了。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [解决出现Incorrect integer value: '' for column 'id' at row 1的问题](https://download.csdn.net/download/weixin_38599712/12871958)[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: 33.333333333333336%"]
- *2* [Incorrect string value: ‘\xE6\x9D\x91\xE4\xB8\x8A...‘ for column ‘name‘错误解决](https://blog.csdn.net/weixin_43206161/article/details/127149996)[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: 33.333333333333336%"]
- *3* [#1366 - Incorrect string value: '\xE6\x9D\xAD\xE5\xB7\x9E...' for column 'title' at row 1](https://blog.csdn.net/qq_34556978/article/details/73883886)[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: 33.333333333333336%"]
[ .reference_list ]
阅读全文