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