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 |