SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '=', query was: SELECT mobile_users.* FROM mobile_users WHERE (first_name = 'John') AND (last_name = 'Rodríguez')
Getting above error when running a select query in php, Last_name is having special character so this issue occurs. but this was working fine in mysql5.7 and now after upgrade to mysql8.0 getting above exception.
How to fix this one without modifying existing production data's in db. My DB structure is (SaaS) Client based dbs. So have many db's which is created using mysql5.7.