BASE64_ENCODE( string-expression )

LONG VARCHAR

• BASE64_DECODE function [String]
• String functions

The following retrieves data from a table containing images and returns it in ASCII format. The resulting string can be embedded into an email message, and then decoded by the recipient to retrieve the original image.

SELECT BASE64_ENCODE( image_data ) FROM IMAGES;