I need to store user uploaded files to our database (and I can't use a file system). The files are all different types and I'm running into a problem deciding if I should use "MEDIUMBLOB" to store these as binary data. And this problem arises from the files having various file sizes.
I understand I need to use "MEDIUMBLOB" as the column type but does the actual memory of the file take up depend on the file size itself or is the memory just allocated based on data type? This will all be done in a MySQL database. Thank you!