WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
ESQL types and schema types
This topic shows the equivalent ESQL and schema data types.
The following table shows the mappings between the Schema type, the ESQL type, and the WebSphere® Message Broker tree type:
XML Schema simple type | 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 | List of CHARACTER |
ENTITY | STRING |
float | FLOAT |
gDay | DATE |
gMonth | DATE |
gMonthDay | DATE |
gYear | DATE |
gYearMonth | DATE |
hexBinary | BLOB |
ID | CHARACTER |
IDREF | CHARACTER |
IDREFS | List of CHARACTER |
int | INTEGER |
integer | DECIMAL |
language | CHARACTER |
long | INTEGER |
Name | CHARACTER |
NCName | CHARACTER |
negativeInteger | DECIMAL |
NMTOKEN | CHARACTER |
NMTOKENS | List of 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 |