Not only are there different character sets that seem like it’s Unicode, but the set in MySQL can change based on the session, the client, the server, the db , the table and the column. All six of them can have different encodings.

Just make sure all are using the same 4 byte Unicode. Different collation is ok when backing up because only important when comparing strings.