Data Type Mapping
The component maps types from Apache CouchDB to the component's own data types. The table below documents these mappings.
The data type that some columns are regarded as by the component 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 |