I have a database dump which contains several languages. Because of that, it's encoded in UTF8. I open the file with the UTF8 encoding and import everything into a UTF8 MySQL database. Everything goes well until it gets to BLOB fields.
For those fields, I get utf8 "\xE3" does not map to Unicode. The lines come by the thousands with all sorts of different characters. I am guessing the BLOB data is Base64 encoded.
To open the file and read it line by line. Is there some way to insert the BLOB data?