Data Types

Numeric Data Types

• Numeric Data Type Overview

  Overview and usage of the numeric data types.
• TINYINT

  Tiny integer, -128 to 127 signed.
• BOOLEAN

  Synonym for TINYINT(1).
• SMALLINT

  Small integer from -32768 to 32767 signed.
• MEDIUMINT

  Medium integer from -8388608 to 8388607 signed.
• INT

  Integer from -2147483648 to 2147483647 signed.
• INTEGER

  Synonym for INT
• BIGINT

  Large integer.
• 2

  DECIMAL

  A packed "exact" fixed-point number.
• DEC, NUMERIC, FIXED

  Synonyms for DECIMAL
• NUMBER

  Synonym for DECIMAL in Oracle mode.
• FLOAT

  Single-precision floating-point number
• DOUBLE

  Normal-size (double-precision) floating-point number
• DOUBLE PRECISION

  REAL and DOUBLE PRECISION are synonyms for DOUBLE.
• BIT

  Bit field type.
• Floating-point Accuracy

  Not all floating-point numbers can be stored with exact precision
• INT1

  A synonym for TINYINT.
• INT2

  Synonym for SMALLINT.
• INT3

  Synonym for MEDIUMINT.
• INT4

  Synonym for INT.
• INT8

  Synonym for BIGINT.

String Data Types

• 2

  String Literals

  under: » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Language Structure
  Strings are sequences of characters and are enclosed with quotes.
• 1

  BINARY

  Fixed-length binary byte string.
• BLOB

  Binary large object up to 65,535 bytes.
• 4

  BLOB and TEXT Data Types

  Binary large object data types and the corresponding TEXT types.
• 1

  CHAR

  Fixed-length string.
• 1

  CHAR BYTE

  Alias for BINARY.
• ENUM

  Enumeration, or string object that can have one value chosen from a list of values.
• INET4

  For storage of IPv4 addresses.
• INET6

  For storage of IPv6 addresses.
• JSON Data Type

  Compatibility data type that is an alias for LONGTEXT.
• MEDIUMBLOB

  Medium binary large object up to 16,777,215 bytes.
• MEDIUMTEXT

  A TEXT column with a maximum length of 16,777,215 characters.
• LONGBLOB

  Long BLOB holding up to 4GB.
• LONG and LONG VARCHAR

  LONG and LONG VARCHAR are synonyms for MEDIUMTEXT.
• 2

  LONGTEXT

  A TEXT column with a maximum length of 4,294,967,295 characters.
• ROW

  Data type for stored procedure variables.
• TEXT

  A TEXT column with a maximum length of 65,535 characters.
• TINYBLOB

  Tiny binary large object up to 255 bytes.
• TINYTEXT

  A TEXT column with a maximum length of 255 characters.
• VARBINARY

  Variable-length binary byte string.
• 2

  VARCHAR

  Variable-length string.
• 1

  SET Data Type

  Set, or string object that can have 0 or more values chosen from a list of values.
• 2

  UUID Data Type

  Data type intended for the storage of UUID data.
• 4

  Data Type Storage Requirements

  under: » MariaDB Server Documentation » Columns, Storage Engines, and Plugins » Data Types
  Storage requirements for the various data types.
• 2

  Supported Character Sets and Collations

  under: » MariaDB Server Documentation » Columns, Storage Engines, and Plugins » Data Types » String Data Types » Character Sets and Collations
  MariaDB supports the following character sets and collations.
• Character Sets and Collations

  Setting character set and collation for a language.

Date and Time Data Types

• DATE

  The date type YYYY-MM-DD.
• TIME

  Time format HH:MM:SS.ssssss
• 5

  DATETIME

  Date and time combination displayed as YYYY-MM-DD HH:MM:SS.
• 7

  TIMESTAMP

  YYYY-MM-DD HH:MM:SS
• YEAR Data Type

  A four-digit year.
• 1

  Future developments for temporal types

  My current project is a forecasting application with dates going out to 263...
• 1

  How to define a date in order to import an empty date from a CSV file?

  I have a CSV file containing amongst other things a couple of date columns....
• 5

  Which datatypes are supported by MariaDB

  I would like to know which datatypes are supported by MariaDB. I'm asking s...

Other Data Types Articles

• Geometry Types

  under: » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » Geographic & Geometric Features
  Supported geometry types.
• 3

  AUTO_INCREMENT

  Automatic increment.
• 4

  Data Type Storage Requirements

  Storage requirements for the various data types.
• 1

  AUTO_INCREMENT FAQ

  Frequently-asked questions about auto_increment.
• 4

  NULL Values

  NULL represents an unknown value.