Data Type Mapping
SingleStore Kai returns the query results as a collection of JSON documents.
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 |
Last modified: July 11, 2023