python如何处理带有emoji表情的字符串

Question

如何才能将从新浪微博抓取的某条含有emoji表情字符的数据添加进mysql数据库,mysql的版本是5.5.x,使用的是python语言。

Answer 1

After searching on the Internet for a long time, I finally found a solution, which is not perfect. My solution is to filter out the emoji characters and not write them to the mysql database.

Answer 2

The essence of emoji is special unicode characters, as long as your database encoding supports unicode. List: http://www.unicode.org/charts/PDF/U1F300.pdf

Answer 3

Just use utf8mb4 encoding for mysql