Data Type Mapping

SingleStore Kai 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

Last modified: July 11, 2023

Was this article helpful?