The driver supports the xml data type. Which JDBC data type the xml data type is mapped to depends on whether the JDBCBehavior and XMLDescribeType properties are set.

  • If XMLDescribeType=longvarchar or XMLDescribeType=longvarbinary, the driver maps the XML data type to the JDBC LONGVARCHAR or LONGVARBINARY data type, respectively, regardless of the setting of the JDBCBehavior property.
  • If JDBCBehavior=1 (default) and the XMLDescribeType property is not set, the driver maps XML data to the JDBC LONGVARCHAR data type.
  • If JDBCBehavior=0 and the XMLDescribeType property is not set, XML data is mapped to SQLXML.