Binary data types support the storage of large amounts of data, such as image and sound files. : Data Type Summary « Data Type « SQL / MySQL






Binary data types support the storage of large amounts of data, such as image and sound files.

      

Data type                     Maximum size
TINYBLOB/TINYTEXT             255 characters (355 bytes)
BLOB/TEXT                     65,535 characters (64 KB)
MEDIUMBLOB/MEDIUMTEXT         16,777,215 characters (16 MB)
LONGBLOB/LONGTEXT             4,294,967,295 characters (4 GB)

   
    
    
    
    
    
  








Related examples in the same category

1. Data Types in MySQL
2.The fractional data types
3.Numeric Column Types
4.Integer Types in MySQL with Sizes and Ranges