SQL Server to MySQL migration, replace '\xA0' with a regular space
Maybe you can use CHARINDEX casting your Address1 to varbinary(8000) to identify the offending data:

select * 
from [ForgeDB].[Snapshot].[SnapshotPersonEmployee]
where charindex(0xA0, cast(Address1 as varbinary(8000))) &gt; 0;


Check this answer: https://dba.stackexchange.com/a/37355/55596