Error on updating a field with binary values
Simply use UNHEX(&quot;1E395565&quot;).
There could be a lot of other issues going on.  So please provide SHOW CREATE TABLE for the old and new tables.  Also provide a sample of what is in the old table, but use
SELECT col, HEX(col) FROM ... WHERE ...

so we can see the value in an unambiguous way.  (That is, not mangled or &quot;fixed&quot; by the client.)
Where does 1E395565 come from?  It is not anything meaningful (not utf8, etc) that I recognize.