This section provides three tables that show how the data types for each supported tabular-formatted XML document map to the standard ODBC data types.

Table 1. Data Islands Data Types
Data Islands Internal XML Name ODBC
binhex bin.hex SQL_LONGVARBINARY
boolean boolean SQL_BIT
currency fixed.14.4 SQL_DECIMAL
date date SQL_TYPE_DATE
dateTime dateTime SQL_TYPE_TIMESTAMP
float float SQL_DOUBLE
i1 i1 SQL_TINYINT SIGNED
i2 i2 SQL_SMALLINT SIGNED
i4 i4 SQL_INTEGER SIGNED
int int SQL_INTEGER SIGNED
number number SQL_DOUBLE
r4 r4 SQL_REAL
r8 r8 SQL_DOUBLE
singleChar singleChar SQL_SMALLINT
string string SQL_WLONGVARCHAR
time time SQL_TYPE_TIME
ui1 ui1 SQL_TINYINT UNSIGNED
ui2 ui2 SQL_SMALLINT UNSIGNED
ui4 ui4 SQL_INTEGER UNSIGNED
Table 2. ADO 2.5 Persisted Files Data Types
ADO 2.5 Persisted Files Internal XML Name ODBC
binhex bin.hex SQL_LONGVARBINARY
boolean boolean SQL_BIT
currency fixed.14.4 SQL_DECIMAL
date date SQL_TYPE_DATE
dateTime dateTime SQL_TYPE_TIMESTAMP
float float SQL_DOUBLE
i1 i1 SQL_TINYINT SIGNED
i2 i2 SQL_SMALLINT SIGNED
i4 i4 SQL_INTEGER SIGNED
i8 i8 SQL_BIGINT SIGNED
int int SQL_INTEGER UNSIGNED
number number SQL_DOUBLE
r4 r4 SQL_REAL
r8 r8 SQL_DOUBLE
singleChar singleChar SQL_SMALLINT SIGNED
time time SQL_TYPE_TIME
ui1 ui1 SQL_TINYINT UNSIGNED
ui2 ui2 SQL_SMALLINT UNSIGNED
ui4 ui4 SQL_INTEGER UNSIGNED
ui8 ui8 SQL_BIGINT UNSIGNED
wchar string SQL_CHAR
wchar string SQL_WCHAR
wlvarchar string SQL_WLONGVARBINARY
wvarchar string SQL_WVARCHAR
Table 3. DataDirect Format Data Types
DataDirect Internal XML Name ODBC
binary binary SQL_BINARY
boolean boolean SQL_BIT
byte byte SQL_TINYINT SIGNED
date date SQL_TYPE_DATE
decimal decimal SQL_NUMERIC
double double SQL_DOUBLE
float float SQL_REAL
int int SQL_INTEGER UNSIGNED
long long SQL_BIGINT SIGNED
lvarbinary binary SQL_LONGVARBINARY
short short SQL_SMALLINT SIGNED
time time SQL_TYPE_TIME
timeInstant timeInstant SQL_TYPE_TIMESTAMP
unsignedByte unsignedByte SQL_TINYINT UNSIGNED
unsignedInt unsignedInt SQL_INTEGER UNSIGNED
unsignedLong unsignedLong SQL_BIGINT UNSIGNED
unsignedShort unsignedShort SQL_SMALLINT UNSIGNED
varbinary binary SQL_VARBINARY
wchar string SQL_CHAR
wchar string SQL_WCHAR
wlvarchar string SQL_WLONGVARBINARY
wvarchar string SQL_WVARCHAR

See Retrieving Data Type Information for information about retrieving data types.