max_packet_length headaches

Swift Griggs · Guest

I've created a system with MySQL 3.21c, Apache 1.3.3, PHP 3.0.6. I've figured out how to get files into the database by using BLOB column types. I've also increased the max_packet_length so that MySQL will accept images larger than 64k, however, it seems that even though the files get uploaded properly and don't get truncated, it looks like either the database won't _show_ more than 64k out of a select, or that the max_packet_lenght didn't have the disired effect. I checked using mysqladmin variables command, but it showed that I had increased the limit to 3Mb. Strange... can someone help?

Swift Griggs · Guest

Hehe. I figured it out. My problem was that I had MySQL working fine and had the max_allowed_packet set plenty high, but the in the table definition I had the column that I was using set as a BLOB and not a MEDIUMBLOB or a LONGBLOB, and the limit on BLOB also happens to be 64k..
DUH! I'm a bonehead sometimes