Home Whiteboard Practice Code Graphing Calculator Online Compilers Articles Tools
Tutorials Courses Jobs

What is the maximum length of data we can put in a TEXT column in MySQL?

MySQL MySQLi Database

As we know TEXT data objects are useful for storing long-form text strings. The different TEXT objects offer a range of storage space from 255 bytes to 4 Gb. The following table shows the storage of different kinds of TEXT data type −

Type of BLOB
 Maximum amount of Data that can be stored
 Overhead
TINYTEXT
 Up to 255 bytes
 1 byte
TEXT
 Up to 64 Kb
 2 bytes
MEDIUMTEXT
 Up to 16 Mb
 3 bytes
LONGTEXT
 Up to 4 Gb
4 bytes
Updated on: 2020-06-20T08:31:13+05:30

4K+ Views

Learn More in Our Tutorials

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements