mysql-backup4j icon indicating copy to clipboard operation
mysql-backup4j copied to clipboard

Refactor: binary data doesn't use String to save

Open FULaBUla opened this issue 3 years ago • 2 comments

Fixed Issue #16

FULaBUla avatar Jul 12 '21 14:07 FULaBUla

@SeunMatt

FULaBUla avatar Jul 15 '21 12:07 FULaBUla

Hello @FULaBUla,

I need some more data before merging this PR. I observed that when you persist raw bytes data into MySQL, it gets converted to a Hex string and then saved in the database. In this case, using getString will successfully backup and restore the data. Leaving the job of conversion from Hex to bytes to the application as it should be.

If we auto convert a column that's in Hex already to another Hex String, when it's restored, it will not function as intended.

Please share more info on how you're storing the binary data and how you're using them after reading from the database.

@ypkkhatri https://github.com/SeunMatt/mysql-backup4j/issues/20 - I will need your contribution as well.

SeunMatt avatar Sep 27 '23 06:09 SeunMatt