Bin data half-transfrred w/ PHP to MySQL

Anon

Hi.

I'm uploading images using forms and PHP to a MySQL database.

What gets there looks like half the image I want to upload. When I go getdata.php?id=1 (a script I took down and customized, someone's article) I get half an image, a distorted image, or something like that. Sometimes there's just the form (dimension info) of an image.

I've also set values for data transfer in php.ini and apache config files well over the image size.

Does anyone have any hints?

Piotr.

Anon

a BLOB/TEXT field is only 2¹⁶ bytes max, or 65,535k .. if you have images larger than that, then they'd be cut off. You need to use a larger field type

BLOB is 2²⁴ = 16 MB, and LONGBLOB is 2³² = 4 GB.

http://www.mysql.com/doc/n/o/node_384.html

ttyl, greg

sitarzp

Hi.

The field datatype is mediumblob. I am sure I won't need a larger datatype... However it still corrupts the JPEG and GIF files either when I upload them or while I download them.

I'm new to PHP and MySQL... Perhaps if you have any checkpoints I should go through, let me know, or any hints or ideas.

Thanks,

Piotr.