mySQL中非法混合的排序规则

I need to transfer a column from one table to another. The source table has a different collation than the target table (latin1_general_ci and latin1_swedish_ci). I need to transfer a column from one table to a