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.

Bug while exporting encrypted columns

disperse's profile image disperse posted 3 years ago in Import/Export Permalink


I've recently upgraded to 9.4, however there is some serious bug while exporting binary columns with encrypted values into text file - all gets malformed.

I had to move back about 11 months to 9.3 for now (don't know when that bug was introduced).

kalvaro's profile image kalvaro posted 3 years ago Permalink

I'm sure Anse will need to know what "encrypted column" means exactly. As far as I know, it's not a native concept neither in MySQL nor in HeidiSQL. (If you don't mean MySQL, you should also say what your DBMS is.)

disperse's profile image disperse posted 3 years ago Permalink

Encrypted values, stored in the DB as binary data ( usually stored as VARBINARY or BLOB ). Not sure about other DBMS but MySQL has native support for encryption via aes_encrypt and aes_decrypt functions.

Export usually (Heidi 9.3) looks like this:

(1, _binary 0x7CF9E42A3EEE064633780DB29695AD7D43204D6FCF7175A949D85E16336E4F8CBCAEC43403E050E220893FC01D36A2F4, when the new one exports something like this:

(1, '[binary content broken and removed]',

PS. This might be related to the libraries supplied, cos installing 9.3 and running 9.4 binary from same directory works fine.

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