MySql 编码坑 utf8 Python emoji utf8mb4
记住:永远不要在MySQL中使用“utf8”,请使用“utf8mb4” utf8mb4_general_ci
cursor.execute("SET character_set_connection=utf8mb4") # pymysql
MySql set varchar to utf8mb4
https://zhuanlan.zhihu.com/p/73402380
https://blog.csdn.net/qq_17555933/article/details/101445526