En este tema se muestran los tipos de datos ESQL y de esquema equivalentes.
La tabla siguiente muestra las correlaciones entre el tipo Esquema, el tipo ESQL y el tipo de árbol de WebSphere Message Broker:
Tipo simple de esquema XML | Tipos de datos del árbol de mensajes |
---|---|
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 |