Comment on Why would a UTF-8 MySQL backup contain invalid UTF-8 characters?
folekaule@lemmy.world 3 weeks agoCharacter encoding and type coercion errors are so common. But a lot of bugs also come from programs trying to do “the right thing”. Like in OP’s case: they are just trying to import some data and maybe the data was never even intended to be interpreted as utf8, but the tool they are using to remove the commands wants to treat it that way. Sometimes the safest thing to do is to just assume data is binary until you care otherwise.