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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.