Extended binary value support

BINARY and VARBINARY are new DB2 version 9.1 SQL datatypes. Use BINARY and VARBINARY to expand support for binary string data, which can contain structured data, encrypted data, compressed data, images, pictures, and other values that are not text-oriented. The BINARY datatype is a fixed-length binary string. The VARBINARY datatype is a variable-length binary string.

Note Replication Agent for DB2 UDB sends the BINARY and VARBINARY values to Replication Server, which then passes the values to the target database for the replicated table. Because some databases may not support BINARY or VARBINARY values, you may need to configure Replication Server and Replication Agent for DB2 UDB to ignore these columns.

See the IBM DB2 version 9.1 for z/OS documentation for more information.