About

Type in 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.

Complex