Using the MySQL Schema compare I have a field in a view which does not sync, it sees the difference every time but does not update it. the difference is:

  CAST(LEFT(`assets`.`AssLocation`, 30) AS char(30) CHARSET utf8) AS `Asst_Locn`,

and

  CAST(LEFT(`assets`.`AssLocation`, 30) AS char(30) CHARSET utf8mb3) AS `Asst_Locn`,

The issue is obviously based around the Charset, is this a setting in the MySQL Servers?