Programster's Blog

Tutorials focusing on Linux, programming, and open-source

MySQL Text Type

Text Types

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

Last updated: 11th December 2020
First published: 11th December 2020