This table shows the mapping between JDBC types and XSD types. When you create a database operation, the data types for the operation input and output are mapped from JDBC types to XSD types as listed in this table.
|
JDBC Data Type |
XSD Data Type |
|
CHAR |
string |
|
VARCHAR |
string |
|
LONGVARCHAR |
string |
|
NUMERIC |
decimal |
|
DECIMAL |
decimal |
|
BIT |
boolean |
|
TINYINT |
byte |
|
SMALLINT |
short |
|
INTEGER |
int |
|
BIGINT |
long |
|
REAL |
float |
|
FLOAT |
double |
|
DOUBLE |
double |
|
BINARY |
base64Binary |
|
VARBINARY |
base64Binary |
|
LONGVARBINARY |
base64Binary |
|
DATE |
date |
|
TIME |
time |
|
TIMESTAMP |
dateTime |