Viewing images and SVGs in Interactive SQL

You can use Interactive SQL to view BLOB data, as well as images that are less than 5000000 pixels. In addition, you can view SVGs and save them to other formats.

Prérequis

You must have the privileges necessary to execute your query.

Your image must be in one of the following formats: BMP (Windows 95 version), GIF, JPG, PNG, SVG, or WBMP (wireless bitmap).

Task

From Interactive SQL, connect to the database.
Execute a query that returns a result set that contains an image.

In the result set, click in a cell that contains (IMAGE), click ..., and then click View in Window.

The Value of Column column-name window appears.

When viewing SVGs, use the following shortcuts:

Shortcut(s)	Description
Ctrl+Left Mouse Button Drag	Drags a boundary so that you can adjust the point of view.
Ctrl+Right Mouse Button Drag	Rotates the image around its center.
Shift+Left Mouse Button Drag	Pans the image to a new location.
Shift+Right Mouse Button Drag	Zooms the image in and out.

Click OK to close the window.

Résultat

The image is viewed.

Exemple

Connect to the sample database and execute the following statement to return JPEG images:

SELECT * FROM GROUPO.Products;

The following window appears when you click the JPEG image associated with the cotton cap:

Connect to the sample database and execute the following statement to return an SVG image:

SELECT '<?xml version="1.0" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" 
"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">

<svg width="100%" height="100%" version="1.1"
xmlns="http://www.w3.org/2000/svg">

<rect width="99" height="99"
style="fill:rgb(0,0,255);stroke-width:1;
stroke:rgb(0,0,0)"/>

</svg>';

Viewing images and SVGs in Interactive SQL

Task

See also