xRobot
Reputation: 26565
TinyText VS LongText !
Maybe this is a very stupid question but... Why should I use tinytext and not longtext ?
In tinytext I can save only 255 chars.
Upvotes: 0
Views: 621
Answers (1)
Sasha Chedygov
Reputation: 130967
It's more efficient. If you don't need more than 255 chars, use it; if you do, then don't. It's as simple as that.
Upvotes: 1
Related Questions
- MySQL: Is there a lack of performance by using LONGTEXT instead of MEDIUMTEXT?
- What is the disadvantage to using a MySQL longtext sized field when every entry will fit within a mediumtext sized field?
- MySQL: Do i use TINYTEXT or VARCHAR(6) for short words
- In MySQL, does LONGTEXT waste space when only TEXT is necessary?
- To use VARCHAR(1000) or LONGTEXT?
- char vs tinytext
- varchar(255) v tinyblob v tinytext
- MySql Tinytext vs Varchar vs Char
- Difference in storage space requirement for TinyText and Text - MySQL
- Which data type saves more space TINYTEXT or VARCHAR for variable data length in MySQL?