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.

Specify Hex Blob when exporting database as SQL

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

HeidiSQL does not convert binary values to hex when exporting as SQL. This causes problems when restoring a database with binary data on it. One problem I had is that when restoring the backup I made with the 'Export database as SQL' feature, all of the columns containing binary data indexed with unique constraint could not be restored due to the fact that there are duplicates, even though there shouldn't be any.

Putting an option to convert binary data to hex when dumping the database as SQL would be very helpful.

MiSAKACHi's profile image MiSAKACHi posted 3 years ago Permalink

Downloaded the latest version (9.4.0.5133)

The binary fields can now be imported/exported properly. Good Job! Cheers :)

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