Adding BLOB and CLOB Data

This feature provides a mechanism adding images, audio, video, or other binary format files

Perform the following steps to add BLOB/CLOB data:

1          Log into WinSQL and establish a database connection. For more information, see “Establishing a Database Connection.”

2          Click the Catalog Details tab.

3          Click the plus sign by Tables.

4          Click the plus sign by the desired table.

5          Click Browse Data.

6          Right-click in the data window, and then click Insert new record. The following window displays:

Note: If any of the fields takes binary or long character data, click the icon in the cell and select either Load data from binary file or Load data from text file.