Converts a binary (
varbyte) value into a hexadecimal string.
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:
stream: Use the default output mode: a continuous stream of hexadecimal bytes, i.e. the same format that
convert(varbyteData, 'varchar')would have returned in Texis version 6 and earlier.
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.
bintohex() function was added in Texis version 7. Caveat:
Note that in version 7 and later,
convert()ing data from/to
varchar no longer converts the data to/from
hexadecimal by default (as was done in earlier versions) in programs
tsql; it is now preserved as-is (though truncated at
varchar). See the
hexifybytes SQL property
(here) to change this.