Jump to content

Archived

This topic is now archived and is closed to further replies.

michaellunsford

mysql blob limited to 64k?

Recommended Posts

trying to insert images into a blob in mysql, but they are apparently being limited to 64k by something. mysql reports that max_allowed_packet is 16777216 -- so I have no idea what the problem could be.

Probably going to rewrite this to work with the regular file system, but it would be nice to know why this isn't working.

Share this post


Link to post
Share on other sites
The BLOB type is limited to 65000 characters (about 64kB). Use MEDIUMBLOB for up to 16MB or LONGBLOB for up to 2GB.

Share this post


Link to post
Share on other sites
[!--quoteo(post=353689:date=Mar 10 2006, 01:40 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Mar 10 2006, 01:40 PM) [snapback]353689[/snapback][/div][div class=\'quotemain\'][!--quotec--]
The BLOB type is limited to 65000 characters (about 64kB). Use MEDIUMBLOB for up to 16MB or LONGBLOB for up to 2GB.
[/quote]

Thanks! You da man. Sorry so long on the reply -- didn't get email notification. Odd.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.