FROM_VARBYTE function - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

FROM_VARBYTE function

FROM_VARBYTE converts a binary value to a character string in the specified format.

Syntax

FROM_VARBYTE(binary_value, format)

Arguments

binary_value

A binary value of data type VARBYTE.

format

The format of the returned character string. Case insensitive valid values are hex, binary, utf8 (also utf-8 and utf_8), and base64.

Return type

VARCHAR

Examples

To convert the binary value 'ab' to hexadecimal, use the following example.

SELECT FROM_VARBYTE('ab', 'hex'); +--------------+ | from_varbyte | +--------------+ | 6162 | +--------------+

To return the binary representation of '4d', use the following example. The binary representation of '4d' is the character string 01001101.

SELECT FROM_VARBYTE(FROM_HEX('4d'), 'binary'); +--------------+ | from_varbyte | +--------------+ | 01001101 | +--------------+