Column Data Types
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Column Data Types
The XML driver determines the column data types by inspecting the column values. The data type determination limits its data types to a subset of the DataDirect Format data types, as listed in the following table. For a complete list of DataDirect Format data types, see Supported Tabular Formats for XML Documents.
| Data Type | Sample Values |
| wvchar | "Foo", "best320" |
| varbinary | "27AB2F9C" |
| int | "34","-7000" |
| unsignedint | "0", "123456789" |
| long | "-12345678012345" |
| unsignedlong | "123456789012345" |
| boolean | "true", "false" |
| date | 1963-12-19 |
| time | 10:09:58 |
| timeinstant | 1963-12-19T10:09:58 |
| decimal | 1245.678 |