MySQL Blob Editor

RazorSQL contains a tool that allows users to work with MySQL blobs, binary data, and image data. Options include the ability to edit blob data, save blob data to a file, and view blob data as an image.

To launch the MySQL blob editor, connect to MySQL and then view the contents of a table that contains a blob or binary column 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".

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 blob or binary column in a new row in a database table, a row should first be inserted containing either a null value for the column or a dummy value. After the new row is inserted, the user can query the table using RazorSQL and launch the binary data editor.