Read a BLOB field

Hello,

To read a Blob or rather to try to read a Blob in PHPMyAdmin you need to modify the config.
You must therefore edit the configuration file "config.inc.php" and modify the line:

- $cfgShowBlob = TRUE; // display blob field contents (for older versions)

- $cfg['ShowBlob']= TRUE; // display blob field contents / (latest versions)

If the variable does not exist, simply create it and it should work.

Since the article is well referenced, this should be useful.

Hello,
Why can't you read it? It's a database field like the others, you just need to query it.
Can you explain in detail, I don't understand your problem

Hello

It doesn’t shock me that phpMyAdmin doesn’t display a blob field. It doesn’t know how to display it, since it can be anything.
But you, you know (we hope...) what’s in your blob, you can make a script that displays it correctly.

Thank you for your responses
yes !! It’s text! , is it obvious to read its content ? !!
is it possible to read the content via PHPMyAdmin ?!! or how to read it
Thank you ...

If it's still text, it's absurd to put it in a blob field; a TEXT or VARCHAR field should have been used!
phpMyAdmin will never display it as text to my knowledge, but with a PHP script you can still read it into a variable and display it with a simple echo.