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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!