This one will be short.
When migrating old DB to a new one, I often come to handle non-utf encoding.
Here’s the code I’m using, so far worked on any “gibberish”, including bad encodings on Hebrew.
CONVERT(CAST(your_field as BINARY) USING utf8)
How from now on I won’t be looking for it for ages..