mysql General error: 1366 Incorrect string value: '\xF0\x9F\x91\x8D\xF0\x9F...' for column 'dianpumiaoshu' at row 1 解决方法 因为传入了emoji表情 曾经考虑过过滤 但是行不通 所以唯一的方法 就是urlencode后存入数据库 读取的时候再urldecode
查看原文：http://newmiracle.cn/?p=2148
相关文章
- SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x90\xA3\xF0\x9F...' for column
- 用naviact 从 sqlserver 迁移 mysql 报错：[2018-08-08 18:58:48] [Err] 1366 - Incorrect string value: '\xF0\x9F\x92\x8D\xE3\x80...' for column 'pc_content' at row 94
- 保存数据时报：Incorrect string value: '\xF0\x9F\x91\x8D' for column 'f_char_name' at row 1
- 在laravel框架中：Error 1366: Incorrect string value: '\xF0\x9F\x91\xBD\xF0\x9F...' for column 'content'
- MySQL (1366, "Incorrect string value: '\\xF0\\x9F\\x8E\\xAC\\xE5\\x89...' for column 'description' at row 1")
- MySQL (1366, "Incorrect string value: '\\xF0\\x9F\\x8E\\xAC\\xE5\\x89...' for column 'description' at row 1")
- mysql General error: 1366 Incorrect string value: '\xF0\x9F\x91\x8D\xF0\x9F...' for column 'dianpumiaoshu' at row 1 解决方法
- mysql General error: 1366 Incorrect string value: '\xF0\x9F\x91\x8D\xF0\x9F...' for column 'dianpumiaoshu' at row 1 解决方法
- MySQL (1366, "Incorrect string value: '\\xF0\\x9F\\x8E\\xAC\\xE5\\x89...' for column 'description' at row 1")