急急急关于utf8mb4字符集

node报错 提示输入表情导致目标表插入报错 uncategorized SQLException for SQL [insert into lxjxc_production.uc_accounts_jxc_lx(aid , account_no , phone , email , name , name_pinyin , avatar_url , gender , source , encrypted_password , reset_password_sent_at , remember_created_at , locked_at , created_at , updated_at , id) values (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update aid=values(aid) , account_no=values(account_no) , phone=values(phone) , email=values(email) , name=values(name) , name_pinyin=values(name_pinyin) , avatar_url=values(avatar_url) , gender=values(gender) , source=values(source) , encrypted_password=values(encrypted_password) , reset_password_sent_at=values(reset_password_sent_at) , remember_created_at=values(remember_created_at) , locked_at=values(locked_at) , created_at=values(created_at) , updated_at=values(updated_at) , id=values(id)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x92\xA4' for column 'name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x92\xA4' for column 'name' at row 1

环境： 源 rds mysql 5.7 库和表的字符集是utf8mb4 目标库 腾讯云 mysql5.7 库为utf8 表为utf8mb4

报错显示是目标表的name 还是utf8导致非法插入了,可是实际表和该字段已经改成utf8mb4 @agapple 请问该如何解决

原提问者GitHub用户smfor