mysql utf8四字节_MySQL在3字节中编码4字节utf8字符串值不正确

川长思鸟来 2023-01-11 13:18 107阅读 0赞

根据mysql documentation，它只支持最多3字节的utf-8unicode编码。

我的问题是，如何替换数据库中需要4字节utf-8编码的字符？我如何解码这些字符以便准确地显示用户所写的内容？在

集成测试的一部分：description = u'baaam á ✓ ✌ ❤'

print description

test\_convention = Blog.objects.create(title="test title",

description=description,

tag=self.tag)

错误：

^\{pr2\}$

表的配置：+----------------------------------+--------+---------+-------------------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+----------+----------------+---------+

\+----------------------------------+--------+---------+-------------------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+----------+----------------+---------+

| blogs\_blog | InnoDB | 10 | utf8\_general\_ci | Compact | 25 | 1966 | 49152 | 0 | 32768 | 0 | 35 | 2014-02-09 00:57:59 | NULL | NULL | NULL | | |

更新：我已经将表和列的配置从utf-8更改为utf8mb4，但仍然得到相同的错误，有什么想法吗？在+----------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+

\+----------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+

| blogs\_blog | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 32768 | 0 | 36 | 2014-02-17 22:24:18 | NULL | NULL | utf8mb4\_general\_ci | NULL | | |

以及：+---------------+--------------+--------------------+------+-----+---------+----------------+---------------------------------+---------+

\+---------------+--------------+--------------------+------+-----+---------+----------------+---------------------------------+---------+

| id | int(11) | NULL | NO | PRI | NULL | auto\_increment | select,insert,update,references | |

| login\_id | int(11) | NULL | NO | MUL | NULL | | select,insert,update,references | |

| tag\_id | int(11) | NULL | NO | MUL | NULL | | select,insert,update,references | |

\+---------------+--------------+--------------------+------+-----+---------+----------------+---------------------------------+---------+