使用python同步数据至MySQL,报错:(pymysql.err.DataError) (1366, 'Incorrect string value: '\xF0\x9F\x98\x9D")
解决方案:
1.将python中MySQL URL编码改为utf8mb4
sqlalchemy_database_url = f’mysql+pymysql://{‘user’}:{‘passwd’}@{‘host’}:{‘3306’}/{‘db’}?charset={‘utf8mb4’}’
2.修改MySQL表对应的编码
alter database teambition character set = utf8mb4 collate = utf8mb4_general_ci;
alter table new_task convert to character set utf8mb4;