I was wondering why in phpMyAdmin I see something like this:
**Edit Inline Edit Copy Delete [BLOB - 7B] [BLOB - 32B] [BLOB - 13B] [BLOB - 16B]**
Why can't I see the actual text? When I click [BLOB-/nx/]
, I just get prompted to download a .BIN file.
I tried adding:
$cfg['ShowBlob'] = true;
To phpMYAdmin/config.inc.php
, but it didn't work. I have also tried adding to the URL &display_blob=true
.
I am trying to do this on localhost with XAMPP by the way.
My version of phpMyAdmin is 3.4.5, if it's needed.
The "Choose file" dialog permits you to pick a file on your workstation and upload it inside the blob column for this row. If your BLOB contains JPEG or PNG images, you can actually view their thumbnails when browsing, with the full image being displayed when you click on the thumbnail.
BLOB Editor is invoked from data grid of any table editor or the result tab of SQL Editor and Visual Query Builder by double clicking of the BLOB field to be edited or with the Edit BLOB link of the field's popup menu. The editor also can be called from BLOB Viewer with the Edit current BLOB button.
In PHPMyAdmin, there is a +Options
above the results table. To show the blob contents:
+Options
Show Blob contents
and press Go
to save.Then, in order to enable the Blob columns to be editable:
Settings
> Main Panel
> Edit Mode
Protect Binary Columns
, click on the right dropdown menu and select no
.Apply
to save.If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With