RazorSQL How to View and Edit Binary Data and Images
RazorSQL contains a binary data editor that allows users to edit binary data, save data to a file, and view binary data as an image. RazorSQL also contains an option that gives users the ability to view binary data in query results as an image. 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.
To edit the binary data or save the binary data to a file, the "Binary Data Editor" option can be selected. Note, this option is only available for tables that have a primary key. After selecting the binary data editor menu item, the binary data editor window will display. There are options for saving the binary data to a file, updating the binary data from a file, viewing the data as an image, or editing the data as character data after specifying a character encoding.
To insert binary data into a new row in a database table, a row should first be inserted containing either a null value for the binary data or a dummy value. After the new row is inserted, the user can query the table using RazorSQL and launch the binary data editor.