How to Directly View Blobs in MySQL Workbench

MySQL Workbench shows results as BLOB

Background:
This problem occurs when the binary string values (BINARY/VARBINARY type) are returned in the results. The binary strings contain the zero bytes and for some reason, apparently security, have not been shown by default. More details about binary strings here.

Even in the reported example SELECT INET_NTOA(167773449), the function returns binary string. Check this for reference.

Solution:
Since MySQL Workbench v5.2.22, it can be set through preferences whether to SHOW or HIDE such values.

  1. In MySQL Workbench, go to: "Edit -> Preferences... -> SQL Queries" OR "Edit -> Preferences... -> SQL Editor -> SQL Execution" (depending upon what version of Workbench you have).
  2. Check the option 'Treat BINARY/VARBINARY as nonbinary character string' to show the actual value.

Reference:
The original issue has been reported and answered with fix here.

How to retrieve a stored image in MySQL Workbench

You can embed image data just like any data in a MySQL table. For binary data you usually would use a BLOB column data type. MySQL Workbench has a built-in editor for binary data, which you can open via the result grid context menu:

enter image description here

This editor allows to view text, hex binary values and images (limited to those formats the platform can show, e.g. on Windows bmp, gif, png, jpg and a few more).

enter image description here

What is "[BLOB - ...]" shown in SQL database column?

Click on Options, tick "Show BLOB contents" and click on Go.



Related Topics



Leave a reply



Submit