Text fields are recovered as BLOBs in MySQL database
Some customers edit MySQL script with recovered database, removing exporting text fields as BLOB type. Please don't do it. SQL script with recovered data should be executed as is. Main problem in exporting tables from SQL file is that there are too many character encodings in the world which cause chaos. The only reasonable way to avoid wrong encoding and make sure all recovered databases are exported correctly is to export text fields as a BLOB type with following conversion on server.
Download MySQL Recovery