This is a discussion on MySQL and blobs within the MySQL Database forums, part of the Database Forums category; Hi I want to store files which are approximently 12mb in size in a database. I've tried using a ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hi I want to store files which are approximently 12mb in size in a
database. I've tried using a BLOB but PHPmyAdmin says they can only be 65000 Bytes. And longBlobs can only be 2mb! I'm sure I've heard somewhere that blobs can hold alot more than that or am i very much mistaken, or is there something else going on? Thanks! |
|
|||
|
On Oct 17, 8:37 am, sophie_newbie <paulgeele...@gmail.com> wrote:
> Hi I want to store files which are approximently 12mb in size in a > database. I've tried using a BLOB but PHPmyAdmin says they can only be > 65000 Bytes. And longBlobs can only be 2mb! I'm sure I've heard > somewhere that blobs can hold alot more than that or am i very much > mistaken, or is there something else going on? > > Thanks! I hope you don't mind that I read the manual for you and found this page: <http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html> |
|
|||
|
On Oct 17, 7:37 am, sophie_newbie <paulgeele...@gmail.com> wrote:
> Hi I want to store files which are approximently 12mb in size in a > database. I've tried using a BLOB but PHPmyAdmin says they can only be > 65000 Bytes. And longBlobs can only be 2mb! I'm sure I've heard > somewhere that blobs can hold alot more than that or am i very much > mistaken, or is there something else going on? > > Thanks! try longblob |