Bug #68383 View binary data as HEX instead of RAW
Submitted: 14 Feb 2013 20:18 Modified: 26 Mar 2013 14:56
Reporter: Ryan Pessa Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.46 OS:Any
Assigned to: CPU Architecture:Any
Tags: BINARY, BLOB, hex, query

[14 Feb 2013 20:18] Ryan Pessa
MySQL Workbench has two options for binary data - BLOB viewer or raw. The BLOB viewer, while great for large BLOBs, is very inconvenient for small binary objects. The raw option is completely useless unless you're storing non-binary data in a binary column.

I would like a hex option that essentially wraps all binary types with HEX() and wraps all inserts/updates with UNHEX(). I looked at the plugin system, but it doesn't seem it is anywhere near capable of such a thing, and the plugin system has a TON of problems anyway (the dearth of documentation, the broken example plugins scripts shipped with the software, having to reload Workbench for every change, etc).

My use case: storing UUIDs as BINARY(16) for quicker lookups.

How to repeat:
Create a table with a BINARY column; insert data.
Select data from table.
BINARY column is either '[BLOB]' or '<unprintable characters>', depending on Workbench settings

Suggested fix:
Create another option alongside the raw binary option for hex binary. Maybe this option could specifically apply to BINARY/VARBINARY fields, while the BLOB viewer would still be used for BLOBs.

Another option would be to display all binary data as hex, with a button on the right of the cell to open the BLOB viewer (best of both worlds).
[26 Mar 2013 14:56] Armando Lopez Valencia
Thanks a lot for your request.