MySQL - TEXT vs CHAR and VARCHAR

mysql text types char varchar

TEXT is a variable length datatype, with a maximum of 65,000 characters.

LONGTEXT can be used for over 4 trillion characters.

To answer your question: it's a variable lenght, and it will only occupy the amount of characters you store.

mysql text types char varchar

TEXT occupies a number actual length of your data + 2 bytes.

CodeHunter