Logical data model types generated from the XML schema to logical data model transformation

The XML schema to logical data model transformation generates logical data model data types from XML schema primitive types.
The following table shows the mapping between XML schema primitive types and logical data model data types.
Table 1. XML schema to logical data model data type mappings
XML schema data types Logical data model data types generated by the transormation
string, normalizedString (if Length facet is set and <= 32672) CHAR
string, normalizedString (if MaxLength facet is set and <= 32672) VARCHAR
string, normalizedString (otherwise) CLOB
base64Binary, hexBinary (if Length facet is set and <= 32672) BINARY
base64Binary, hexBinary (if MaxLength facet is set and <= 32672) VARBINARY
base64Binary, hexBinary (otherwise) BLOB
short, unsignedShort, byte, unsignedByte SHORT
integer, positiveInteger, nonPositiveInteger, negativeInteger, nonNegativeInteger, int, unsignedInt INTEGER
long, unsignedLong LONG
float FLOAT
double DOUBLE
decimal DECIMAL
boolean BOOLEAN
date DATE
duration INTERVAL
time,gMonth, gYear, gYearMonth, gDay, gMonthDay TIME
dateTime TIMESTAMP
token, language, NMTOKEN, NMTOKENS, Name, NCName, ID, IDREF, IDREFS, ENTITY, ENTITIES anyURI, NOTATION, QName VARCHAR(32672)

Feedback