How to store photos in database?

Question

PHP

A 16kb(jpg) photo is sent from the form. On the server, the script converts it to base64 and writes it to the database. When fetching from the database, it already weighs 250kb.
What is the reason for the increase in file size and how to get rid of it?

Answer 1

we create a table, one of the columns of which is of a binary type, and write it there directly through the insert file.
In general, in the search it can be found on the first page
janicky.com/stati/sohranenie-izobrazhenij-v-baze-d...

Answer 2

You can not convert to base64, but simply write binary data to the blob field, I suspect the size will increase in this case only slightly.