Question

What is TEXT data type in MySQL?

Answer 1

Answer:

Besides CHAR and VARCHAR character types, MySQL provides us with TEXT type that has more features which CHAR and VARCHAR cannot cover.

The TEXT is useful for storing long-form text strings that can take from 1 byte to 4 GB. We often find the TEXT data type for storing article body in news sites, product description in e-commerce sites.

Different from CHAR and VARCHAR, you don’t have to specify a storage length when you use a TEXT type for a column. In addition, MySQL does not remove or pad spaces when retrieve or insert text data like CHAR and VARCHAR.

Explanation: