Text - Data Type

Primitive

• Fixed text, size N means that the column must be able to hold any string of characters of a fixed length of N. If the string it holds is shorter than N characters, then trailing spaces must be stored in the database or the database must automatically pad with spaces upon retrieval such that a CHAR_LENGTH() function will return N.
• Variable text, size N means that the column must be able to hold any string of characters of a variable length with a maximum length of N.

• Text - String

Complex

• text tree (wiki/Rope_(data_structure)