Altova DatabaseSpy 2023 Enterprise Edition

Binary content can be stored in databases using the following data types:

In DatabaseSpy you can choose to (i) save binary content from the result grid to a file, or (ii) load binary content from a file and store it in the database. The respective menu entries are available when you click the button inside a data cell of the result grid.

DatabaseSpy presents the standard Windows Open, respectively the Save As, dialog box for this purpose. Binary content can be saved to the following formats BIN, BMP, JPG, PNG, MP3, AVI, and PDF.

To change the binary content of a database data cell:

1.Click the Browse button inside the data cell you want to edit.

2.From the menu that appears, select Load Binary from File... or Save Binary to File....

3.Do one of the following:

•In the Open dialog box, browse to the desired binary file and click Open.

•In the Save As dialog box, select the folder where you want to save the binary file, enter a name for the file, and click Save.

4.To commit your changes to the database, click the button in the Result window toolbar.