Description:
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).