Aikesheng Open Source Community

Jul 16, 2019 · Databases

Storing and Retrieving Large Image Files in MySQL: Comparing LONGBLOB, LONGTEXT, and VARCHAR

This article demonstrates how to store 5 MB images in MySQL using LONGBLOB, LONGTEXT, and VARCHAR columns, compares their disk usage, shows insertion scripts, and provides retrieval methods including a stored procedure for binary export, concluding that storing file paths is more efficient.