Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

blob data export bug

damhye's profile image damhye posted 2 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.)

damhye's profile image damhye posted 2 years ago Permalink

my temporary fix

2 attachment(s):
Code modification/commit 651b485 from Ansgar Becker <anse@heidisql.com>, 2 years ago, revision 5239
Apply fix from forum user damhye, for wrong octet length of exported blob data. See https://www.heidisql.com/forum.php?t=24843
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 2 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>, 1 year ago, revision 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.