The following table shows the recommended datatype for mapping specific SQL datatypes. The second column of the table shows which TSD types are recommended as the most suitable choices for the corresponding SQL type. Types not explicitly marked as not indexable are indexable.
SQL Datatype | Preferred XML Schema/TSD Datatype | Comment |
---|---|---|
CHAR , VARCHAR |
xs:string
|
|
LONGVARCHAR ,
CLOB |
- | not supported |
BIT |
xs:boolean |
|
BIGINT |
- | not supported, could e.g. be mapped to
xs:short |
INTEGER |
xs:int |
depending on implementation of SQL database |
SMALLINT |
xs:short |
|
TINYINT |
- | not supported, could e.g. be mapped to
xs:short |
DECIMAL(precision,scale) |
xs:decimal |
|
NUMERIC(precision,scale) |
xs:decimal |
|
REAL |
xs:float |
|
DOUBLE |
xs:double |
|
DATE |
xs:date |
|
TIME |
xs:time |
|
TIMESTAMP |
- | xs:datetime not yet supported, could
be mapped to xs:string |
INTERVAL(DAY-TIME) |
- | could be mapped to xs:string |
INTERVAL(YEAR-MONTH) |
- | could be mapped to xs:string |
BINARY |
- | not supported |
VARBINARY |
- | not supported |
LONGVARBINARY ,
BLOB |
- | not supported |