2.1.08b. Data types and domains (MySQL)

  • Numeric
    • TINYINT, INT, INT UNSIGNED
    • FLOAT, DOUBLE, DECIMAL
    • ENUM
    • Character-string
      • CHAR(n) - n is length
      • VARCHAR(n) - n is max
      • TINYTEXT, TEXT
      • Beware different default/maximum lengths to Oracle
    • BLOB
    • Multi-database comparison of Datatypes