Table 15.1[Datatype mapping] is maps XML datatypes with RDBMS datatypes.
| XML | sql92 | postgresql | mysql |
|---|---|---|---|
| string | VARCHAR(128) | TEXT | TEXT |
| normalizedString | VARCHAR(64) | TEXT | TEXT |
| token | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| boolean | BIT | BOOLEAN | BIT |
| type | TINYINT | SMALLINT | TINYINT |
| short | SMALLINT | SMALLINT | SMALLINT |
| int | INTEGER | INTEGER | INTEGER |
| long | BIGINT | BIGINT | BIGINT |
| unsignedByte | SMALLINT | SMALLINT | SMALLINT |
| unsignedShort | INTEGER | INTEGER | INTEGER |
| unsignedInt | BIGINT | BIGINT | BIGINT |
| unsignedLong | BIGINT | BIGINT | BIGINT |
| float | REAL | REAL | REAL |
| double | FLOAT | FLOAT88 | FLOAT |
| decimal | DECIMAL | DECIMAL | DECIMAL |
| base64Binary | BLOB | VARBIT | BLOB |
| hexBinary | BLOB | VARBIT | BLOB |
| anyURI | VARCHAR(64) | VARCHAR(64) | VARCHAR(64) |
| language | VARCHAR(8) | VARCHAR(8) | VARCHAR(8) |
| Name | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| QName | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| NCName | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| integer | BIGINT | BIGINT | BIGINT |
| nonNegativeInteger | BIGINT | BIGINT | BIGINT |
| positiveInteger | BIGINT | BIGINT | BIGINT |
| nonPositiveInteger | BIGINT | BIGINT | BIGINT |
| negativeInteger | BIGINT | BIGINT | BIGINT |
| time | TIME | TIME | TIME |
| date | DATE | DATE | DATE |
| dataTime | TIMESTAMP | TIMESTAMP | DATETIME |
| gYearMonth | CHAR(7) | CHAR(7) | CHAR(7) |
| gYear | CHAR(4) | CHAR(4) | CHAR(4) |
| gMonthDay | CHAR(5) | CHAR(5) | CHAR(5) |
| gDay | CHAR(2) | CHAR(2) | CHAR(2) |
| gMonth | CHAR(2) | CHAR(2) | CHAR(2) |
| duration | VARCHAR(2) | VARCHAR(2) | VARCHAR(2) |
| CDATA | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| NMTOKEN | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| NMTOKENS | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| ID | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| IDREF | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| IDREFS | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| ENTITY | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| ENTITIES | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| NOTATION | VARCHAR(32) | VARCHAR(32) | VARCHAR(32) |
| fragment | (system) | TEXT | TEXT |