MySQL Text Type

Text Types

• TEXT columns can’t have DEFAULT values, unlike CHAR and VARCHAR objects.
• Benchmarking Varchar vs TEXT

TINYTEXT

• 255 characters
• Storage Space: 255 bytes
• Pretty pointless using this instead of varchar(255).

TEXT

• 65535 characters
• Storage Space: 64 KB

MEDIUMTEXT

• 16,777,215 characters
• Storage Space: 16 MB

LONGTEXT

• 4,294,967,295 characters
• Storage Space: 4 GB

BIGINT

• Unsigned Range 0 - 18446744073709551615
• Signed Range -9223372036854775808 - 9223372036854775807
• Storage Space: 8 bytes

References

• Chartio.com - Understanding Storage Sizes for MySQL TEXT Data Types