BLOB Editor

Previous  Top  Next

The BLOB Editor - Tools | BLOB Editor - allows you to store, retrieve and edit large binary data. It can be opened from the Tools menu item or by double clicking a BLOB column in any data-grid. It's used together with an SQL Editor or opened data in the Table Editor: if you have an opened dataset, the BLOB Editor will show it on the left of its window.


BLOBs are stored as untyped data - the BLOB Editor nor the database engine knows what it's storing, so when you open the BLOB Editor, it will default to the first tab - "As Text" - if it detects a text-blob and to "As Hex" for all other blob types.


The BLOB Editor allows you to view the BLOB-data in multiple ways. You have to select the type that suits the data. The "As Image" tab supports 4 types of images. A Text BLOB is also called a CLOB.


The BLOB Editor


As you can see in the picture above, there's a single BLOB Editor for all database connections and SQL Editors/Table Editors. In the treeview on the left, it will display the column source and connection. In the right pane, there's different views on the column data.


From the toolbar, there's some buttons to Load and Save BLOB data. These will use a direct BLOB stream, unless you're at the As OLE tab. This will create an OLE object from file and insert that into the BLOB column.


Then there are navigational buttons and a Post Edit and Cancel Edit buttons. You need to use the Post Edit button in order to save the changes to the underlying dataset.



Committing the changes isn't done from the BLOB Editor, but from the editor that has the opened dataset - for example, the SQL Editor.
The "As Image" tab supports several different image formats and attempts to detect the format automatically. If it fails, you can set it by hand.