Results 1 to 1 of 1
Jul 20, 2009, 07:44 #1
- Join Date
- Sep 2000
- 0 Post(s)
- 0 Thread(s)
Database Dump: UTF8 Encoding with BLOB Fields?
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?