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

Reply via email to