Viewing images 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, such as JPEG, PNG, and TIFF.

Supported image formats include: BMP (Windows 95 version), GIF, JPEG, PNG, PNM, SVG, TIFF, and WBMP (wireless bitmap).

 To view images and SVGs (Interactive SQL)
  1. Connect to the database. For example, connect to the SQL Anywhere sample database.

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

    For example, run the following to return JPEG images:

    SELECT * FROM products;

    Run the following 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>
    ' -- Don't forget this closing quote
  3. In the result set, click in a cell that contains (IMAGE), click ..., and then choose View in Window.

    The Value of Column column-name window appears.

    For example, the following window appears when you click the JPEG image associated with the cotton cap:

    Value of Column column-name window.

    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 Cancel to close the window.