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)