# Data Types

SingleStore supports the following data types. The sizes given are for in-memory rowstore tables. Columnstore (on-disk) tables are stored differently, and often compressed.

The sections below provide in-depth information about various data types as well as data type conversion and comparing mismatched data types.

## In this section

* [Integer Numbers](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/integer-numbers.md)
* [Real Numbers](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/real-numbers.md)
* [Time and Date](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/time-and-date.md)
* [String Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/string-types.md)
* [Encoding String Data in Columnstore Tables](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/encoding-string-data-in-columnstore-tables.md)
* [Binary String Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/binary-string-types.md)
* [JSON Type](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/json-type.md)
* [BSON Type](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/bson-type.md)
* [Geospatial Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/geospatial-types.md)
* [SingleStore Procedural SQL (PSQL) Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/singlestore-procedural-sql-psql-types.md)
* [Other Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/other-types.md)
* [Vector Type](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/vector-type.md)
* [Comparing Mismatched Datatypes](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/comparing-mismatched-datatypes.md)
* [Data Type Conversion](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/data-type-conversion.md)

***

Modified at: March 5, 2026

Source: [/db/v9.1/reference/sql-reference/data-types/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/)

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