UTF8 Trouble while migrating from MSSQL to MySQL with MySQL Workbench
Hex A0 probably came from a Word document, where it is a "hard space".

It appears that you did not specify that the source was 'latin1' and the destination is 'utf8'.  Otherwise, A0 should have turned into C2A0.  That seems correct.  However, this seems incorrect: "Driver sends Unicode data as UTF-8".  Or perhaps just inconsistent with "Collation SQL_Latin1_General_CP1_CI_AS migrated to utf8_general_ci".  Did you do anything in ODBC to tell it to convert latin1 to utf8?

You have an inconsistency -- some places you mention utf8, some mention utf8mb4.  Outside MySQL, there is only "utf8" (or "UTF-8"), but inside MySQL there is a difference between utf8 and utf8mb4.  If you intend to handle Chinese or Emoji, go with utf8mb4.