DEV Community

Cover image for MySQL - Column types for storing text
Walter Nascimento
Walter Nascimento

Posted on

MySQL - Column types for storing text

See below what are the types of columns that MySQL supports for storing texts and what are the characteristics of each type.

CHAR(size)

Type Max character size
String 255

VARCHAR(size)

Type Max character size
String 65.535

TINYTEXT

Type Max character size
String 255

TEXT

Type Max character size
String 65.535

MEDIUMTEXT

Type Max character size
String 16.777.215

LONGTEXT

Type Max character size
String 4.294.967.295

BLOB

Type Max character size
Binary Large OBject 65.535

MEDIUMBLOB

Type Max character size
Binary Large OBject 16.777.215

LONGBLOB

Type Max character size
Binary Large OBject 4.294.967.295

Thanks for reading!

If you have any questions, complaints or tips, you can leave them here in the comments. I will be happy to answer!
😊😊 See you! 😊😊


Support Me

Youtube - WalterNascimentoBarroso
Github - WalterNascimentoBarroso
Codepen - WalterNascimentoBarroso

Top comments (0)