MySQL and blobs

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