运行·获取的微博内容出现特殊字符不能写入·mysql数据库

[shuangxi2006]

为了更好的解决问题，请认真回答下面的问题。等到问题解决，请及时关闭本issue。

• 问：请您指明哪个版本运行出错（github版/PyPi版/全部）？

答：pypi版本 0.0.2

• 问：您使用的是否是最新的程序（是/否）？

答：是

• 问：爬取任意用户都会运行出错吗（是/否）？

答：是

• 问：若只有爬特定微博时才出错，能否提供出错微博的weibo_id或url（非必填）？

答：

• 问：若您已提供出错微博的weibo_id或url，可忽略此内容，否则能否提供出错账号的user_id及您配置的since_date，方便我们定位出错微博（非必填）？

答：

• 问：如果方便，请您描述出错详情，最好附上错误提示。

答：pymysql.err.DataError: (1366, "Incorrect string value: '\xF0\x9F\x8E\xA5F1...' for column weibo.weibo.content at row 1")

[dataabc]

感谢反馈。您把数据库编码改成utf8mb4看看。

[shuangxi2006]

是的现在的编码已经是：utf8mb4_unicode_ci，服务器默认是：utf8mb4_general_ci

[shuangxi2006]

I confirmed the database, table, column character set were all utf8mb4.

The problem was solved by changing the field type to longtext.

Hope this could help someone.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.