title: Does MySql support variable length file storing data type?
body: <p>This is not a duplicate question as marked by <strong>PM 77-1, Drew</strong>
  I have a simple question that if I want to store only 1MB file then do I need to use only MEDIUMBLOB (in this case 15 MB will be left free).</p>
  
  <p>As we know that the <strong>MEDIUMBLOB</strong> stores file upto 16 MB, but as per my knowledge if I store a 1 MB file then 15 MB space for that row will be a waste.</p>
  
  <p><em>Is it correct?</em></p>
  
  <p>I want to store a specific 1 MB file for every user but didn't get any specific data type in MySql. <em>Do we have some data type that have the maximum 1 MB space?</em> or <em>Do we have any variable length data type ?</em></p>
  
  <p>Please revert.</p>