データタイプマッピング
The connector maps types from Apache CouchDB to the connector's own data types. The table below documents these mappings.
The data type that some columns are regarded as by the connector 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 |