Jump to content


Photo

mysql blob limited to 64k?


  • Please log in to reply
2 replies to this topic

#1 michaellunsford

michaellunsford
  • Members
  • PipPipPip
  • Advanced Member
  • 1,023 posts
  • LocationLouisiana, USA

Posted 10 March 2006 - 05:43 PM

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.


#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 10 March 2006 - 07:40 PM

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

#3 michaellunsford

michaellunsford
  • Members
  • PipPipPip
  • Advanced Member
  • 1,023 posts
  • LocationLouisiana, USA

Posted 13 March 2006 - 04:31 PM

[!--quoteo(post=353689:date=Mar 10 2006, 01:40 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Mar 10 2006, 01:40 PM) View Post[/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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users