Data Type Mapping
SingleStore Kai for MongoDB returns the query results as a collection of JSON documents. Refer to BSON to JSON for more information. The following table maps SingleStoreDB data types to the corresponding BSON data types :
SingleStoreDB Data Type | BSON Data Type |
|---|---|
BIGINT | INT64 |
BINARY | BINARY (subtype 0) |
BIT | INT32 or INT64 |
BLOB | BINARY |
CHAR | STRING |
DATE | DATETIME |
DATETIME | DATETIME |
DATETIME(6) | DATETIME |
DECIMAL | INT32, INT64, DOUBLE, or DECIMAL (based on size) |
DOUBLE | DOUBLE |
ENUM | STRING |
FLOAT | DOUBLE |
GEOGRAPHY | STRING |
GEOGRAPHYPOINT | STRING |
INT | INT32 |
JSON | BSON |
LONGBLOB | BINARY |
LONGTEXT | STRING |
MEDIUMBLOB | BINARY |
MEDIUMINT | INT32 |
MEDIUMTEXT | STRING |
SMALLINT | INT32 |
TEXT | STRING |
TIME | STRING |
TIMESTAMP | DATETIME |
TIMESTAMP6 | DATETIME |
TINYBLOB | BINARY |
TINYINT | BOOLEAN |
TINYTEXT | STRING |
VARBINARY | BINARY |
VARCHAR | STRING |
YEAR | INT32 |