Tuesday, August 25, 2015

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;
Next
This is the most recent post.
Older Post

0 comments:

Post a Comment

Breaking News
Loading...
Quick Message
Press Esc to close
Copyright © 2013 Technology KB All Right Reserved