Mapping of SQL and JDBC Data Types to XML Data Types - IBM Database Add-Ins for Visual Studio

The data type of a parameter or column of a result set in a message is specified by using XML data types.

The following table shows the default mappings from SQL and JDBC data types to XML data types.

DB2^® SQL type	Informix^® SQL type	JDBC type	XML type
BIGINT	INT8	java.sql.Types.BIGINT	xsd:long
CHAR FOR BIT DATA, BINARY	BYTE	java.sql.Types.BINARY	xsd:base64Binary
		java.sql.Types.BIT	xsd:short
BLOB		java.sql.Types.BLOB	xsd:base64Binary
	BOOLEAN	java.sql.Types.BOOLEAN	xsd:boolean
CHAR, GRAPHIC	CHAR	java.sql.Types.CHAR	xsd:string
CLOB, DBCLOB		java.sql.Types.CLOB	xsd:string
DATALINK		java.sql.Types.DATALINK	xsd:anyURI
DATE	DATE	java.sql.Types.DATE	xsd:date
DECIMAL, DECFLOAT	DECIMAL	java.sql.Types.DECIMAL	xsd:decimal
DOUBLE		java.sql.Types.DOUBLE	xsd:double
REAL	FLOAT	java.sql.Types.FLOAT	xsd:float
INTEGER	INTEGER	java.sql.Types.INTEGER	xsd:int
	BLOB	java.sql.Types.LONGVARBINARY	xsd:base64Binary
	CLOB, TEXT	java.sql.Types.LONGVARCHAR	xsd:string
	MONEY	java.sql.Types.NUMERIC	xsd:decimal
	SMALLFLOAT	java.sql.Types.REAL	xsd:float
SMALLINT	SMALLINT	java.sql.Types.SMALLINT	xsd:short
TIME	DATETIME HOUR TO SECOND	java.sql.Types.TIMESTAMP	xsd:time
TIMESTAMP	DATETIME YEAR TO FRACTION	java.sql.Types.TIMESTAMP	xsd:dateTime
		java.sql.Types.TINYINT	xsd:short
VARCHAR FOR BIT DATA, VARBINARY		java.sql.Types.VARBINARY	xsd:base64Binary
VARCHAR, VARGRAPHIC	VARCHAR	java.sql.Types.VARCHAR	xsd:string
		java.sql.Types.ARRAY	xsd:string
		java.sql.Types.DISTINCT	xsd:string
		java.sql.Types.JAVA_OBJECT	xsd:string
		java.sql.Types.NULL	xsd:string
		java.sql.Types.OTHER	xsd:string
		java.sql.Types.REF	xsd:string
		java.sql.Types.STRUCT	xsd:string
ROWID		100	xsd:base64Binary
XML		2009	xsd:anyType
		Any other type that is not listed	xsd:string

Mapping of SQL and JDBC Data Types to XML Data Types (DB2)