Data Types for MariaDB Xpand 6.0
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Reference for MariaDB Xpand 6.0
Topics on this page:
Overview
Each column in a table has a specified data type that defines what kind of data can be stored in the column.
Data Type | Class | Description |
---|---|---|
Integer | Integer from -128 to 127 when signed, or from 0 to 255 when unsigned | |
Integer | Integer from -32768 to 32767 when signed, or from 0 to 65535 when unsigned | |
Integer | Integer from -8388608 to 8388607 when signed, or from 0 to 16777215 when unsigned | |
Integer | Integer from -2147483648 to 2147483647 when signed, or from 0 to 4294967295 when unsigned | |
Integer | Integer from -9223372036854775808 to 9223372036854775807 when signed, or from 0 to 18446744073709551615 when unsigned | |
Fixed Num | Fixed-point number | |
Float | Single-precision floating-point number | |
Float | Double-precision floating-point number | |
String | Fixed-length string with limit up to 1023 bytes | |
String | Variable-length string with limit up to 65,535 bytes | |
String | String for variable-length text data up to 255 bytes | |
String | String for variable-length text data up to 65,535 bytes | |
String | String for variable-length text data up to 16,777,215 bytes | |
String | String for variable-length text data up to 67,108,864 bytes | |
String | String for variable-length binary data up to 255 bytes | |
String | String for variable-length binary data up to 65,535 bytes | |
String | String for variable-length binary data up to 16,777,215 bytes | |
String | String for variable-length binary data up to 67,108,864 bytes | |
String | Fixed-length string for binary data with limit up to 255 bytes | |
String | Variable-length string for binary data with limit up to 65,535 bytes | |
Bit | Bit data | |
Set | One or more comma-separated values from a set of up to 64 pre-selected options | |
Set | A single value from up to 65,535 pre-selected options | |
Time | Hours, minutes, seconds, and microseconds | |
Date | Four-digit year | |
Date | Year, month, day | |
Date/Time | Year, month, day, hours, minutes, seconds, and microseconds, and supporting dates between the years 1970 and 2038 | |
Date/Time | Year, month, day, hours, minutes, seconds, and microseconds, and supporting dates between the years 1000 and 9999 | |
String | A native JSON data type that converts the assigned value into an internal JSON representation | |
Alias | This is an alias for | |
String | See CHAR | |
Fixed Num | See DECIMAL | |
Fixed Num | See DECIMAL | |
Float | See DOUBLE | |
Float | See DOUBLE | |
Integer | See TINYINT | |
Integer | See TINYINT | |
Integer | See TINYINT | |
Integer | See SMALLINT | |
Integer | See MEDIUMINT | |
Integer | See INT | |
Integer | See INT | |
Integer | See BIGINT | |
String | See CHAR | |
String | See CHAR | |
String | See CHAR |