Adaptive Server version 15.7 includes the disable varbinary truncation configuration parameter, which enables or disables the truncation of trailing zeros from varbinary and binary null data.
By default, disable varbinary truncation is off for the server.
See "Adding, Changing, Transferring, and Deleting Data" in the Transact-SQL Users Guide.