VARBINARY_TO_VARCHAR

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > Conversion Functions >

VARBINARY_TO_VARCHAR

Previous pageReturn to chapter overviewNext page

SYS_BOOT.MGMT.VARBINARY_TO_VARCHAR(sourceBytes VARBINARY(65535))

 RETURNS VARCHAR(65535)

 

This function converts a VARBINARY value into the corresponding hex-encoded binary string. For example, this converts the byte array [1,2,3,4] into the string '01020304'. The inverse operation is

SYS_BOOT.MGMT.VARCHAR_TO_VARBINARY().

5_2_indicator

Version 5.2 Feature

As of version 5.2, you no longer need to use the preface SYS_BOOT.MGMT.