MySQL phpmyadmin - show BLOB to a viewable format
When using phpmyadmin to list out the records from a table, it will display a link for download a bin file if the field format is defined in BLOB.If you want to display the content directly, you can using the convert function as below:
SELECT CONVERT('field_name' USING utf8) FROM table;
