VARCHAR_TO_VARBINARY

<< Click to Display Table of Contents >>

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

VARCHAR_TO_VARBINARY

Previous pageReturn to chapter overviewNext page

SYS_BOOT.MGMT.VARCHAR_TO_VARBINARY(sourceString VARCHAR(65535))

 Returns VARBINARY(65535)

 

This function converts a hex-encoded binary string (suitable for use as a VARBINARY literal) into the corresponding VARCHAR value. For instance, it converts the string '01020304' into the byte array [1,2,3,4].

The inverse operation is SYS_BOOT.MGMT.VARBINARY_TO_VARCHAR().

5_3_indicator

Version 5.3 Feature

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