https://slingdata.io logo
Powered by
Good Evening. I have a MySQL database
# sling-help
a
Good Evening. I have a MySQL database with a mediumblob column containing the binary contents of a PDF file. I am using sling to move this to another MySQL database, however it seems that sling converts this to mediumtext column. I believe a step or process within sling is corrupting the data - my measure for this, is that on the original database I can select the contents of the mediumblob column into a dumpfile and open it as a valid PDF, but if I try the same on the destination database, whilst the PDF opens and has the correct number of pages, there is no contents.
As a very basic piece of debug info, comparing the first 100 characters of source/destination, you can see characters changed: MariaDB [(none)]> select LEFT(CertBlob,100) FROM source.
tbl
WHERE 
Finished
= '2026-05-31 22:20:16.000000'; +------------------------------------------------------------------------------------------------------+ | LEFT(CertBlob,100) | +------------------------------------------------------------------------------------------------------+ | %PDF-1.4 %âã 1 0 obj << /Title (▒▒ C e r t i f i c a t e) /Creator () /Producer (▒▒ Q t 5 . 1 2 | +------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) MariaDB [(none)]> select LEFT(CertBlob,100) FROM destination.
tbl
WHERE 
Finished
= '2026-05-31 22:20:16.000000'; +--------------------------------------------------------------------------------------------------------+ | LEFT(CertBlob,100) | +--------------------------------------------------------------------------------------------------------+ | %PDF-1.4 %âã 1 0 obj << /Title (? C e r t i f i c a t e) /Creator () /Producer (? Q t 5 . 1 2 . 5) | +--------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec)
f
Hi @AnEnglish you're correct, will be fixed in next release, thnks for raising this.
a
Oh, thanks! Do you know when that release would be? Thanks for creating this project, it's so straightforward and does exactly what I need
f
Target is end of this week.
a
@flarco I just installed the new release, the issue is now resolved - thank you so much!
2 Views
PreviousNext
Powered by