A tabela a seguir mostra os mapeamentos padrão de tipos de dados SQL e JDBC para tipos de dados XML.
Tipo DB2 SQL | Tipo Informix SQL | Tipo JDBC | tipo de XML |
---|---|---|---|
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 | |
Qualquer outro tipo que não está listado | xsd:string |