michaellunsford Posted March 10, 2006 Share Posted March 10, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/4621-mysql-blob-limited-to-64k/ Share on other sites More sharing options...
wickning1 Posted March 10, 2006 Share Posted March 10, 2006 The BLOB type is limited to 65000 characters (about 64kB). Use MEDIUMBLOB for up to 16MB or LONGBLOB for up to 2GB. Quote Link to comment https://forums.phpfreaks.com/topic/4621-mysql-blob-limited-to-64k/#findComment-16193 Share on other sites More sharing options...
michaellunsford Posted March 13, 2006 Author Share Posted March 13, 2006 [!--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. Quote Link to comment https://forums.phpfreaks.com/topic/4621-mysql-blob-limited-to-64k/#findComment-17035 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.