Data Types for MariaDB Xpand 5.3
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Xpand 5.3
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.
Integer Numeric Types
Data Type | Class | Description |
---|---|---|
Integer | Integer from -9223372036854775808 to 9223372036854775807 when signed, or from 0 to 18446744073709551615 when unsigned | |
Bit | Bit data | |
Integer | See TINYINT | |
Integer | See TINYINT | |
Integer | Integer from -2147483648 to 2147483647 when signed, or from 0 to 4294967295 when unsigned | |
Integer | See TINYINT | |
Integer | See SMALLINT | |
Integer | See MEDIUMINT | |
Integer | See INT | |
Integer | See BIGINT | |
Integer | See INT | |
Integer | Integer from -8388608 to 8388607 when signed, or from 0 to 16777215 when unsigned | |
Alias | This is an alias for | |
Integer | Integer from -32768 to 32767 when signed, or from 0 to 65535 when unsigned | |
Integer | Integer from -128 to 127 when signed, or from 0 to 255 when unsigned |
Non-integer Numeric Types
Data Type | Class | Description |
---|---|---|
Fixed Num | See DECIMAL | |
Fixed Num | Fixed-point number | |
Float | Double-precision floating-point number | |
Float | See DOUBLE | |
Float | Single-precision floating-point number | |
Fixed Num | See DECIMAL | |
Float | See DOUBLE |
String Types
Data Type | Class | Description |
---|---|---|
String | Fixed-length string for binary data with limit up to 255 bytes | |
String | String for variable-length binary data up to 65,535 bytes | |
String | Fixed-length string with limit up to 1023 bytes | |
String | See CHAR | |
String | A native JSON data type that converts the assigned value into an internal JSON representation | |
String | String for variable-length binary data | |
String | String for variable-length text data | |
String | String for variable-length binary data up to 16,777,215 bytes | |
String | String for variable-length text data up to 16,777,215 bytes | |
String | See CHAR | |
String | See CHAR | |
String | See CHAR | |
String | String for variable-length text data up to 65,535 bytes | |
String | String for variable-length binary data up to 255 bytes | |
String | String for variable-length text data up to 255 bytes | |
String | Variable-length string for binary data with limit up to 65,535 bytes | |
String | Variable-length string with limit up to 65,535 bytes |
Date & Time Types
Data Type | Class | Description |
---|---|---|
Date | Year, month, day | |
Date/Time | Year (1000-9999), month, day, hours, minutes, seconds | |
Time | Hours, minutes, seconds, and microseconds | |
Date/Time | Accepts a datetime value consisting of year (1970-2038), month, day, hours, minutes, seconds, and microseconds | |
Date | Four-digit year |