Data Type Mapping
The add-in maps types from Apache CouchDB to the add-in's own data types. The table below documents these mappings.
The data type that some columns are regarded as by the add-in is dynamically assessed based on the values in the column. Possible type determinations are shown as comma-separated values below.
The number of rows checked when determining the data type of a column is controlled by the RowScanDepth connection property.
Apache CouchDB | CData Data Type |
string | VARCHAR, INTEGER, BIGINT, DOUBLE, BOOLEAN, DATE, TIME, TIMESTAMP |
number | INTEGER, BIGINT, DOUBLE |
boolean | BOOLEAN |
object | VARCHAR (FlattenObjects=false) |
array | VARCHAR (FlattenArrays=0) |
null | VARCHAR |