TINYTEXT

TEXT

MEDIUMTEXT

LONGTEXT

With the advent of Social Media Data Mining and NoSQL Data Structures, mechanisms were needed to store these large (usually Key Value pairs) in a SQL database until they could be deconstructed

They are similar to BLOBs but the data is stored in text configurations like XML or JSON

Character Large Objects or CLOBs