Upper memory limit on BLOB fields

[Bastien Koert]

Having a real issue here with storing files in the table where the blob file size is voer 16Meg. Anything under we can get in and out with no problems. Anything over 16M is a problem. We can and have chunked the data thru a loop to get it into the table. But once in there, getting it out is proving problematical.

The error is 'exceeded max_allowed_packets'. Yet the max_allowed_packets setting is 32M.

We have tried with both

1. ASP / Mysql 4.0.x / mySQL Connector 3.51

2. PHP 4.3.x / MySQL 4.0.x

Is there a mysql client setting that needs to be changed somewhere?

Is there something in the connector that can be adjusted?


If anyone has any ideas, I appreciate them. Or if you require more info, please let me know.

TIA

Bastien

cat, the other other white meat