On 9/18/05, Bill Whillers <[EMAIL PROTECTED]> wrote: > When using Storable freeze/thaw to work with basic object (hash) storage > within a mysql db (blob column), I can't seem to get any more than 65535 > bytes stored. > > Since 65535 appears to be a "magic" number, I've been digging for where my > problem might reside (Storable, Perl, etc). but knowing many on this list > use Storable to do lots of cool things, can someone provide a clue?
I'm going to guess that max_allowed_packet is set to 64K. Thereby limiting the size of blob that you can read or set. See http://dev.mysql.com/doc/mysql/en/blob.html for details. If you need only a small amount more, you could compress the string in memory before storing it and reverse that the other way. If you need a lot more, then you're going to have to do some real work, sorry. Cheers, Ben