bintohex

Converts a binary (varbyte) value into a hexadecimal string.

    bintohex(varbyteData[, 'stream|pretty])

A string (varchar) hexadecimal representation of the varbyteData parameter is returned. This can be useful to visually examine binary data that may contain non-printable or nul bytes. The optional second argument is a comma-separated string of any of the following flags:

  \item \verb`stream`: Use the default output mode: a continuous
    stream of hexadecimal bytes, i.e. the same format that
    \verb`convert(varbyteData, 'varchar')` would have returned in
    Texis version 6 and earlier.

  \item \verb`pretty`: Return a ``pretty'' version of the data: print
    16 byte per line, space-separate the hexadecimal bytes, and print
    an ASCII dump on the right side.

The bintohex() function was added in Texis version 7. Caveat: Note that in version 7 and later, convert()ing data from/to varbyte/varchar no longer converts the data to/from hexadecimal by default (as was done in earlier versions) in programs other than tsql; it is now preserved as-is (though truncated at nul for varchar). See the hexifybytes SQL property (here) to change this.