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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

AVG function [Aggregate] Next Page

BASE64_DECODE function [String]

Decodes data using the MIME base64 format and returns the string as a LONG VARCHAR.


BASE64_DECODE( string-expression )


string-expression    The string that is to be decoded. Note that the string must be base64-encoded.

See also
Standards and compatibility

SQL/2003    Vendor extension.


The following inserts an image into an image table from an embedded SQL program. The input data (host variable) must be base64 encoded.

EXEC SQL INSERT INTO images ( image_data ) VALUES ( BASE64_DECODE ( :img ) );