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 gets altered at import/export

Paulus's profile image Paulus posted 2 months ago in General Permalink

Hi all,

I have a strange problem: i have a blob containing a gzip file. When viewing this in gridview i see the content is stored correct (first few bytes are gzip header: 01f8b08000) but when exporting this i get a file with first few bytes 01fefbfbd08000) which is not a valid gzip.

What happened, why did heidisql transform the bytes???

best regards,

Paul

ansgar's profile image ansgar posted 2 months ago Permalink

Which export method was it? Tools / SQL Export?

Paulus's profile image Paulus posted 2 months ago Permalink

No from the gridview on the table contents you can open a popupmenuon for the blobfield and there there are options to save blob to file or load blob from file.

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




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.