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

Data Type Mapping

Was this article helpful?

Was this article helpful?