BASE64_DECODE( string-expression )

LONG VARCHAR

• BASE64_ENCODE function [String]
• String functions

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