Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpMyAdmin - Show BLOB fields as text?

Tags:

phpmyadmin

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.

like image 694
sackbot14 Avatar asked Mar 18 '12 22:03

sackbot14


People also ask

How to view BLOB data in phpMyAdmin?

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.

How can I change BLOB data in MySQL?

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.


1 Answers

In PHPMyAdmin, there is a +Options above the results table. To show the blob contents:

  1. Click +Options

enter image description here

  1. Then click Show Blob contents and press Go to save.

enter image description here

Then, in order to enable the Blob columns to be editable:

  1. Go to Settings > Main Panel > Edit Mode
  2. In the row Protect Binary Columns, click on the right dropdown menu and select no.
  3. Press Apply to save.

enter image description here

like image 127
Mahmoud Abdelsattar Avatar answered Sep 17 '22 13:09

Mahmoud Abdelsattar