zzzprojects
Error with BLOB column
When performing a BulkInsert into a MySQL (8.X and 9.3) table with a BLOB column (SNAPSHOT) from a VB.NET Byte() column, the operation fails with the error:
Cannot convert string '\xFF\xD8\xFF\xE0\x00\x10...' from binary to utf8mb4
- Z.BulkOperations v2.13.15.
- Table Charset: utf8mb4
- Table Collation: utf8mb4_0900_ai_ci
- The issue occurs even if the Byte() array contains valid BLOB data.
- The LogDump: -- @0_16: (Type = String, Size = 16777215)
Thanks for the help. Kind Regards Marin
Hello @mpriala-code,
Could you try the latest version and let us know if this issue still occurs?
The version you’re using dates back to 2018. Many issues have been fixed over the past seven years, and this one is likely already resolved if it’s the one we think it is.
Best Regards,
Jon
Yes, this is the result:
- Z.BulkOperations v5.2.4.
- The LogDump: -- @0_16: (Type = Object, Size = 65535)
- App in 64
Best regards. Marin.
Hello @mpriala-code,
Could you create a small runnable project that reproduces the issue? It doesn’t have to be your actual project—just a new solution with the minimum code. If possible, please include your my.ini (or relevant DB configuration), as that could help.
My developer tested both of your reported issues, and both worked correctly on our side.
You can send the project privately to [email protected].
Best Regards,
Jon
Hello @JonathanMagnan
Thanks for the quick reply. We've just isolated the issue and sent a sample code project to the e-mail you provided.
Best regards, Marin