Editing Binary Columns

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Retrieving and Editing Data >

Editing Binary Columns

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

 

Oracle

BLOB, LONG RAW, RAW, BFILE

MS SQL Server

binary, varbinary, image

MS Access

BINARY, IMAGE

MySQL

binary, tinyblob, varbinary, blob, mediumblob, longblob

IBM DB2

BLOB

IBM DB2 for i

BLOB, BINARY LARGE OBJECT, BINARY, VARBINARY

SQLite

BLOB

Sybase

binary, varbinary, image

PostgreSQL

byte array

 

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 ic_change-binary button inside a data cell of the result grid.

tab_result-change-binary

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 ic_change-binary 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 ic_commit button in the Result window toolbar.

 

Note:MS Access does not support the loading of a binary file in a binary column.

 

Note:When connecting to PostgreSQL through the ODBC driver, select the bytea as LO check box on the second page of the advanced data source options of the PostgreSQL driver settings.

ds_postgresql_binary_dlg


© 2019 Altova GmbH