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

sometimes can export Blob data but cannot import them

Open FULaBUla opened this issue 3 years ago • 1 comments

problem

I using Blob/TinyBlob/MediumBlob in MySql8. Sometimes i can export data from database but i cannot import them when read Blod data from file, java.sql will throw exception because MysqlExportService.java_Line:258 will convert binary data to string and some strange characters in the string which will cause the subscripts to cross the bounds.

I think we need to add judgment sentence when the type is LONGVARBINARY and save data like 0x00001abc maybe can solve this problem

FULaBUla avatar Jun 29 '21 12:06 FULaBUla

Please provide code examples of how you normally insert the blob data into the database and how you use them once they're pulled out of the database.

Given that Blob data are hexadecimally encoded before saving into the database, the getString function should work seamlessly. Please provide more info to help with this

SeunMatt avatar Oct 01 '23 16:10 SeunMatt