Returning XML data as binary data
- Last Updated: June 5, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- Microsoft SQL Server 6.0
- 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.