About XML attachment tables
The XML for the attachment type TABLE contains metadata for each of the columns, including the type, notes, and the rows of data.
Each column has the format specified in the <DBType>
element. The integer value for each data type is determined by the integer values in Java and their respective SQL data types:
Table A–1 Data types
Value |
Data Type |
Description |
2 |
NUMERIC |
Specifies one of the following:
|
12 |
VARCHAR |
Specifies a string. |
91 |
DATE |
Specifies a date without time in a string using the ISO8601 format, such as 1997-07-16 in the format YYYY-MM-DD. |
93 |
TIMESTAMP |
Specifies a timestamp with the date and time in a string using the ISO8601 format, such as 1997-07-16T19:20:30Z in the format YYYY-MM-DDThh:mm:ssZ where:
|