Incorrect string value: '\xF0\x9F\x98\x8A. ...' for column
来源:互联网 发布:淘宝客贷款流程 编辑:程序博客网 时间:2024/04/29 13:32
原文地址: http://blog.csdn.net/reiliu/article/details/8764681
最近再存储表情字符时报错 Incorrect string value: '\xF0\x9F\x98\x8A. ...' for column。找了很久
最后发现还是字符编码的问题,。我用的是mysql数据库。而Emoji表情或者某些特殊字符是4个字节,而Mysql的utf8编码最多3个字节,所以数据插不进去。
然后我把报错的字段的编码类型换成utf-8mb4就好了
0 0
- Incorrect string value: '\xF0\x9F\x98\x8A. ...' for column
- python mysql 1366, u"Incorrect string value: '\\xF0\\x9F\\x98\\x8A' for column 'content' at row 1"
- mysql:Incorrect string value: '\xF0\x9F\x98\xB8' for column
- Incorrect string value: '\xF0\x9F\x98\x92' for column 'NIKENAME' at row 1;
- java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8E' for column 'nick' at row 1
- 彻底解决:Incorrect string value: '\xF0\x9F\x98\xAD",...' for column 'commentContent' at row 1
- java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\xB3' for column 'Content' at row 1
- Incorrect string value: '\xF0\x9F\x98\x84\xF0\x9F
- Incorrect string value: '\xF0\x9F\x98\x84\xF0\x9F
- mysql Incorrect string value \xF0\x9F\x98\x84\xF0\x9F
- Incorrect string value: '\xF0\x9F\x98\x84\xF0\x9F
- Incorrect string value: '\xF0\x9F\x91\x93\xF0\x9F...' for column 'xxx' at row 1
- Mysql插入数据 Incorrect string value: '\xF0\x9F\x98\x84
- Incorrect string value: '\xF0\x9F\x92\x8B \xF0...' for column nickanme
- mysql General error: 1366 Incorrect string value: '\xF0\x9F\x91\x8D\xF0\x9F...' for column 'dianpumiaoshu' at row 1 解决方法
- 在laravel框架中:Error 1366: Incorrect string value: '\xF0\x9F\x91\xBD\xF0\x9F...' for column 'content'
- Incorrect string value: '\xF0\x9F\x92\x90</...' for column 'xxx' at row 1
- 保存数据时报:Incorrect string value: '\xF0\x9F\x91\x8D' for column 'f_char_name' at row 1
- ViewDragHelper详解(一)
- HDU 5642 King's Order 数位dp
- vim 替换
- Java并发编程:线程间协作的两种方式:wait、notify、notifyAll和Condition
- Android 单位转换(dp、sp、px)
- Incorrect string value: '\xF0\x9F\x98\x8A. ...' for column
- mac os android ndk 配置环境变量设置笔记
- Oracle 11g学习1——基础介绍
- static_cast、dynamic_cast、const_cast和reinterpret_cast总结
- JAVA多线程和并发基础面试问答
- 一个叫做Widget的类
- ViewDragHelper详解(二)
- android 中不同的Xml中id可以重名吗?
- Java线程面试题 Top 50 (转载)