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)