BLOB / CLOB Viewer

Displays the content of a single BLOB or CLOB cell from the SQL Console result grid.
Opens by clicking the ... button on the right edge of a BLOB or CLOB cell.

Display Modes

The viewer selects a mode automatically based on cell type and content:

Condition Display
CLOB (text) Read-only text area. Title bar shows character count and byte size.
BLOB — recognised image Image rendered in a canvas (JPEG, PNG, GIF, BMP, TIFF, ICO, WMF).
BLOB — other binary Hex dump of the first 4096 bytes. Title bar shows the full size.
Empty / NULL Empty display, size 0.

Truncated Content

When the cell was truncated by the BLOB budget or per-cell cap, the viewer shows only the truncated portion.

Download Full Content — fetches the complete value from the server, bypassing the budget for this cell only. The button is shown when all of the following conditions are met:

If the button is not shown and a red label explains that the download is unavailable, re-run the query with SELECT * or include all primary key columns explicitly. If the column is aliased or the source table cannot be determined, increase Max KB in the SQL Console toolbar and re-run the query to receive the full value directly.

Buttons

Button Availability Action
Save to File When content is complete (not truncated, or after downloading) Saves to disk. CLOBs as UTF-8 with BOM; BLOBs with format suggestions based on detected image type.
Download Full Content When content is truncated and all PK columns are present in the result Fetches the complete value and enables Save to File.
Close Always Closes the viewer.

When content is truncated but the download is unavailable (missing or partial primary key, or aliased column), a red label in the button bar explains why and how to enable the download.

See Also

(C) 2026 Easygate, Lda