Displaying a BLOB field in Grid Results (or Edit Table Data) will display the data as a hex string such as "74657374".

Choosing to "View Cell in.. Text Viewer" or "View as Text" also displays it as the same hex string but instead should display it as text, similarly with "View Cell in.. HTML" or XML or Browser.

For instance, a BLOB that contains "74657374" should display "test".

Given that often times BLOBs are very large, displaying something like "Binary 345 bytes" might be more appropriate then displaying the hex string in the Grid Results, in which case it would also make sense to add a "View Cell in.. Hex" option for BLOBs.

Better yet would be auto-detection of the contents of the BLOB, automatically identifying images, XML/HTML, PDF, text and instead of displaying "Binary", it would display "PDF" (or appropriate).

In the Edit Table Data you should be able to edit it as text (maybe a Edit in Window as Text option?).

This functionality should likely also include other related variants of binary type fields, such as shortblob, binary, varbinary, etc