Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Encodes data using the MIME base64 format and returns it as a 7-bit ASCII string.
BASE64_ENCODE( string-expression )
The string that is to be encoded.
The following retrieves data from a fictitious 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;