ESQL to XML Schema data type mapping
Mapping from XML Schema simple type to ESQL message tree data type.
The following table shows the mapping that IBM® App Connect Enterprise parsers use when converting between the simple types of XML Schema and the data types of the message tree. The mapping applies to all parsers that use an XML Schema model when parsing and serializing.
| XML Schema simple type | ESQL data type in message tree |
|---|---|
| anyURI | CHARACTER |
| base64Binary | BLOB |
| boolean | BOOLEAN |
| byte | INTEGER |
| date | DATE |
| dateTime | TIMESTAMP |
| dayTimeDuration | INTERVAL |
| decimal | DECIMAL |
| double | FLOAT |
| duration | INTERVAL |
| ENTITIES | Repeating set of elements in the tree, each of type CHARACTER |
| ENTITY | CHARACTER |
| float | FLOAT |
| gDay | DATE |
| gMonth | DATE |
| gMonthDay | DATE |
| gYear | DATE |
| gYearMonth | DATE |
| hexBinary | BLOB |
| ID | CHARACTER |
| IDREF | CHARACTER |
| IDREFS | Repeating set of elements in the tree, each of type CHARACTER |
| int | INTEGER |
| integer | DECIMAL |
| language | CHARACTER |
| long | INTEGER |
| Name | CHARACTER |
| NCName | CHARACTER |
| negativeInteger | DECIMAL |
| NMTOKEN | CHARACTER |
| NMTOKENS | Repeating set of elements in the tree, each of type CHARACTER |
| nonNegativeInteger | DECIMAL |
| nonPositiveInteger | DECIMAL |
| normalizedString | CHARACTER |
| NOTATION | CHARACTER |
| positiveInteger | DECIMAL |
| QName | CHARACTER |
| short | INTEGER |
| string | CHARACTER |
| time | TIME |
| token | CHARACTER |
| unsignedByte | INTEGER |
| unsignedInt | INTEGER |
| unsignedLong | DECIMAL |
| unsignedShort | INTEGER |
| yearMonthDuration | INTERVAL |