Support for Preserving Trailing Zeros

Open Client and Open Server version 15.7 support the disable varbinary truncation configuration parameter introduced in Adaptive Server 15.7. This parameter specifies whether Adaptive Server preserves or truncates trailing zeros from varbinary and binary null data.

Versions of Adaptive Server earlier than 15.7 and versions of bcp, and bulklib earlier than 15.7 truncate trailing zeros for varbinary datatypes. Versions of Adaptive Server 15.7 or later and versions of bcp, and bulklib 15.7 or later can truncate or preserve the trailing zeros of varbinary datatypes.

By default, disable varbinary truncation is 0 (off) for the server. Set it to 1 (on) to enable the feature.