Binary Data
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
When XMLDescribeType=longvarbinary, the driver returns XML data as binary data. The result set column is described with a column type of LONGVARBINARY and the column type name is xml.
Your application can use the following methods to return XML data as binary data:
- ResultSet.getBytes()
- ResultSet.getBinaryStream()
- ResultSet.getBlob()
- ResultSet.getObject()
- CallableStatement.getBytes()
- CallableStatement.getBlob()
- CallableStatement.getObject()
The driver does not apply any data conversions to the XML data returned from the database server. These methods return a byte array or binary stream that contains the XML data encoded as UTF-8.
If XMLDescribeType=longvarchar, your application should not use any of the
methods for returning binary data described in this section. In this case, the driver
applies the standard JDBC binary-to-character conversion to the data, which returns the
hexadecimal representation of the binary data.