Problem: I can INSERT BLOB data > 64K just fine (many MB in fact), and I can UPDATE with data less than 64k, but as soon as I try UPDATE with one byte over the magic 65535 it goes *poof* (exception with a warnings: 1).
Can anyone else reproduce?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Problem: I can INSERT BLOB data > 64K just fine (many MB in fact), and I can UPDATE with data less than 64k, but as soon as I try UPDATE with one byte over the magic 65535 it goes *poof* (exception with a warnings: 1).
Can anyone else reproduce?
Sounds like truncation. BLOB only holds 64K worth of data. Try using a MEDIUM BLOB instead.
http://www.mysql.com/doc/n/o/node_369.html