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.
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).
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:
|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.
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>';
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|