Size of a BLOB value in MySQL

Use the following query to get the Size of Image column for each row. "Image" is a column defined as MEDIUMBLOB in a MySQL database

Select ID, name, OCTET_LENGTH(Image) from catalog


Was very useful in making sure my PHP script to upload Images to the database was working okay or not!