# BSON Data Type Mapping

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](https://www.mongodb.com/docs/manual/reference/mongodb-extended-json/) format (Relaxed or Canonical).
* BSON can be casted to JSON using the `:>JSON` notation. 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 :

| **SingleStoreData 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                                           |
| VECTOR(F32)              | BSON Array of DOUBLE type elements               |
| VECTOR(F64)              | BSON Array of DOUBLE type elements               |
| VECTOR(I8)               | BSON Array of INT32 type elements                |
| VECTOR(I16)              | BSON Array of INT32 type elements                |
| VECTOR(I32)              | BSON Array of INT32 type elements                |
| VECTOR(I64)              | BSON Array of INT64 type elements                |
| YEAR                     | INT32                                            |

***

Modified at: April 25, 2025

Source: [/cloud/reference/singlestore-kai/data-type-mapping/](https://docs.singlestore.com/cloud/reference/singlestore-kai/data-type-mapping/)

(An index of the documentation is available at /llms.txt)