Data Types

Don't see the content you are looking for above? Try these related English language items.

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.