Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

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.

Prerequisites

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
  1. From Interactive SQL, connect to the database.

  2. Execute a query that returns a result set that contains an image.

  3. 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.
  4. Click OK to close the window.

Results

The image is viewed.

Example

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:

Value of Column column-name window.

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>';

 See also