Binary functions

This page describes the available functions to assist with working with binary data.

base64#

base64(data, maxLength) encodes raw binary data using the base64 encoding into a string with a maximum length defined by maxLength.

Arguments:

  • data is the binary data to be encoded.
  • maxLength is the intended maximum length of the encoded string.

Return value:

Return value type is string.

tip

rnd_bin can be used to generate random binary data.

Example:

SELECT base64(rnd_bin(), 20);
base64
q7QDHliR4V1OsAEUVCFwDDTerbI=