Bug report of picture in blob field.

[expired user #9996]'s profile image [expired user #9996] posted 8 years ago in General Permalink

When use heidisql to insert pictures (tested with jpg/png/bmp) into a mediumblob field, the result is incorrect.

Like I insert a png file which is 26664 bytes, The length of the content after insert will be 24819 bytes.

I also tried using some other mysql admin tools, like sqlyog, to insert pic into mediumblob field(the result is correct), then use heidisql to read from the mediumblob field. The result is incorrect too. Heidisql will complains like "read stream error" or "picture data CRC error". Sometimes it will crash.

Please login to leave a reply, or register at first.