The output of the INTTOHEX function is now compatible with the output of Adaptive Server Anywhere functions. Depending on the input, which can be up to a 64-bit integer, the output of INTTOHEX can be 8 digits or 16 digits and is left padded with zeros; the return data type is VARCHAR rather than BINARY. The output of INTTOHEX no longer has a “0x” or “0X” prefix.
The output of the INTTOHEX function can also be controlled by setting the database option ASE_FUNCTION_BEHAVIOR.
For more information, see “INTTOHEX function [Data type conversion]” in Chapter 5, “SQL Functions,” and “ASE_FUNCTION_BEHAVIOR option” in Chapter 2, “Database Options,” in the Sybase IQ Reference Manual.
