Aspects


vs


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
Better

"I think tinyint is better than varchar in this case"

from question "Managing user points on Q&A site"

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?"

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"

Back to Home
Data comes from Stack Exchange with CC-BY-SA-3.0