How to Edit Binary Data

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. 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" for supported databases.

To edit the binary data, save the binary data to a file, or view the binary data as an image, 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 via the Binary Data Editor menu option of the query results cell.