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