mysql:Incorrect string value: '\xF0\x9F\x98\xB8' for column

最新推荐文章于 2024-01-05 14:16:49 发布

原创最新推荐文章于 2024-01-05 14:16:49 发布 · 4.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

摘录所见所闻专栏收录该内容

27 篇文章

订阅专栏

本文探讨了iOS平台上特定Emoji字符在MySQL中显示为'Incorrect string value'的原因。该问题源于MySQL utf8字符集不支持四字节的补充字符，如部分Emoji。文章解释了utf8与utf8mb4字符集之间的区别，并建议使用utf8mb4以确保所有Unicode字符的兼容性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql:Incorrect string value: ‘\xF0\x9F\x98\xB8’ for column
原因是ios平台的emoji不受mysql当前字符集支持。
@seehttp://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html

10.1.10.6 The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)
The character set named utf8 uses a maximum of three bytes per character and contains only BMP characters.
As of MySQL 5.5.3, the utf8mb4 character set uses a maximum of four bytes per character supports supplemental characters:
For a BMP character, utf8 and utf8mb4 have identical storage characteristics: same code values, same encoding, same length.
For a supplementary character, utf8 cannot store the character at all, while utf8mb4 requires four bytes to store it. You need not worry about converting characters or losing data when upgrading utf8 data from older versions of MySQL.
基本多文种平面（Basic Multilingual Plane, BMP），或称第0平面或0号平面（Plane 0），是Unicode中的一个编码区段。编码从U+0000至U+FFFF。