How to View Data as an Image

There are two ways to view data as an image using RazorSQL. One is the Binary Data Editor, and the other is the "View as Image" tool. Both of these are available via the right-click / context menu of query results cells that contain binary data. Note: the binary data editor and image viewing tool are not available for all databases, and are not available if connecting via a PHP, JSP, or ASP bridge or a service connection.

To launch the binary data editor, view the contents of a table with binary data by using the view contents option of the database browser, or by running a select query against the table. Once the results are displayed in the query results section, the right-click / context menu of a results cell that contains binary data will contain options called "Binary Data Editor" and "View as Image" for supported databases.

For most databases, RazorSQL will display binary data in hex format unless otherwise specified in the preferences. If the hex data represents an image, the "View as Image" option in the right-click menu of the query results cell will convert the hex data into an image and display it in a new window.

There is also an option for viewing image data on the Binary Data Editor. Note, the binary data editor is only available for tables that have a primary key. After selecting the binary data editor menu item via the context menu of a query results cell that contains binary data, the binary data editor will be launched.