Aspects
Tinyint
Tinyint is one of the Exact number data types that use integer data.
Varchar
A varchar or variable character field is a set of character data of indeterminate length.
Others
| Quality | Example |
|---|---|
| More |
"As varchar n takes spaces much more than tinyint and your main table is table2 so the second scenario is more optimize" from question "Is it more effecient to have a table with one of its columns mostly empty or make a new table and refer to it?" |
| Better |
"I think tinyint is better than varchar in this case" from question "Managing user points on Q&A site" |
| Less |
"Using varchar is less efficient than using tinyint like aju john suggested in his comment but unless i m dealing with a really performance-critical or a huge table - i find it easier to deal with" from question "Alternative to ENUM Datatype in MySQL" |