FROM_VARBYTE function - Amazon Redshift
SyntaxArgumentsReturn typeExamples

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 |
+--------------+