image upload to mySQL

[timbob]

I am trying to upload an image to mySQL. I have set the value of the filed to BLOB but I am unsure as to what value to place in the length value field.

Do i need to enter a value here if so what is a good size???

help much appreciatted

[laserlight]

What do you mean by "length value field"? If you want to choose between the different types, read: Data Type Storage Requirements.

It may be better to just store the path to an image, then upload the image to the filesystem instead of the database.

[Jack_McSlay]

I agree it is indeed better to store just the path and put the actual file somewhere else. performance may take a hit if you put the file on the database and also, useful functions to handle images, such as mime_content_type(), getimagesize() and imagecreatefromjpeg() only works for files.

but to clear you of questions, you can't specify the length on BLOB types. There's only four possible lengths for a BLOB field:
TINYBLOB: 255B (8-bit file size)
BLOB: ~ 64KB (16-bit file size)
MEDIUMBLOB: ~ 16.8MB (24-bit file size)
LONGBLOB: ~ 4GB (32-bit file size)