Data Type Mapping
On this page
SingleStore Kai natively supports the BSON data type for storage.
Note
The BSON type and BSON-specific functions must only be used for directly querying tables created by SingleStore Kai using SQL.
BSON Type Conversion
-
For all BLOB/string to BSON casting, SingleStore interprets the source as raw BSON bytes.
-
For JSON to BSON casting, SingleStore converts the JSON data according to the MongoDB® Extended JSON V2 format (Relaxed or Canonical).
-
BSON can be casted to JSON using the
:>JSONnotation.This conversion is performed in the MongoDB® Extended JSON V2 Relaxed format.
The following table maps SingleStore data types to the corresponding BSON data types :
|
SingleStore 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: January 6, 2024