blob data export bug

[expired user #11229]'s profile image [expired user #11229] posted 6 years ago in Import/Export Permalink

hello.

when import a exported data(sql) that containing blob data type, I have confirmed that the OCTET_LENGTH is different from the original.

it works well when i export using Toad Edge or mysqldump and import using HeidiSQL. but, it works wrong when i export using HeidiSQL.

(tested under Windows7 64bit, mariadb 10.0.11.)

[expired user #11229]'s profile image [expired user #11229] posted 6 years ago Permalink

my temporary fix

2 attachment(s):
Code modification/commit 651b485 from Ansgar Becker <anse@heidisql.com>, 6 years ago, revision 9.5.0.5239
Apply fix from forum user damhye, for wrong octet length of exported blob data. See https://www.heidisql.com/forum.php?t=24843
ansgar's profile image ansgar posted 6 years ago Permalink

I just committed your additions in r5239.

Normally you should post such changes as a pull request on GitHub, after having a fork of Heidi in your own repo. Probably I can also add you as a contributor in the HeidiSQL repository. Are you familiar with GitHub a bit?

Code modification/commit 611c311 from Ansgar Becker <anse@heidisql.com>, 5 years ago, revision 9.5.0.5341
Fix sloppy code from damhye in TDBQuery.GetColBinData(), see https://www.heidisql.com/forum.php?t=24843

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