Re: [PHP4BETA] Image File Upload Into MySQL BLOB

I would think a regular BLOB at minimum should work right? According to the mSQL/MySQL book a BLOB can hold 64KB, a MEDIUMBLOB can hold 16MB, and a LONGBLOB can hold 4GB of data. If my guys are uploading images larger than 64KB then we have more pressing issues to deal with. :) -Darrell ----- Original Message ----- From: Mohammad A. Haque <mhaque@haque.net> To: Darrell Brogdon <dbrogdon@consumerforce.com> Cc: PHP4 <php4beta@lists.php.net> Sent: Thursday, December 16, 1999 3:22 PM Subject: Re: [PHP4BETA] Image File Upload Into MySQL BLOB > Actually, I just realized I am dong one thing different. I'm using > longblob. > > -- > > ============================================= > http://www.haque.net/ > Post your screenshots: > http://www.haque.net/screenshots/ > mhaque@haque.net > ============================================= > > > Darrell Brogdon wrote: > > > > I have a script that pretty much follows any documentation I can find on using File Upload to send an image to the server and save it as a BLOB (MEDIUMBLOB to be exact) in my MySQL database. The upload seems to go fine but when I retrieve it from the database I find that the filesize is about 10 bytes less than the original file. > > > > Has anybody else experienced this phenomenon? I'm using PHP4.0b3, MySQL v3.22.26a, and Apache 1.3.9 > > > > Darrell Brogdon > > ConsumerForce > > http://www.consumerforce.com >