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

Syntax

BASE64_DECODE( string-expression )

Parameters

Returns

LONG VARCHAR

See also

• BASE64_ENCODE function [String]
• String functions

Standards and compatibility

Example

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