Skip to main content

Data Types

Badaso supports data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type.

Numeric Data Types#

  • TINYINT
  • SMALLINT
  • INT
  • MEDIUMINT
  • BIGINT
  • DECIMAL
  • DOUBLE
  • FLOAT
  • BOOLEAN

Date & Time Data Types#

  • DATE
  • TIME
  • DATETIME
  • TIMESTAMP
  • YEAR

String Data Types#

  • TEXT
  • BLOB
  • CHAR and VARCHAR
  • BINARY and VARBINARY
  • ENUM
  • SET
  • MEDIUM TEXT
  • LONG TEXT

Spatial Data Types#

  • GEOMETRY
  • POINT
  • LINESTRING
  • POLYGON
  • MULTIPOINT
  • MULTILINESTRING
  • MULTIPOLYGON
  • GEOMETRYCOLLECTION

JSON Data Type#

  • JSON