BLOB gets altered at import/export

Paulus's profile image Paulus posted 3 years 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 3 years ago Permalink

Which export method was it? Tools / SQL Export?

Paulus's profile image Paulus posted 3 years 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.