topic Re: Extract Mysql MEDIUMBLOB (Image) one by one in Design and Developmenthttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46659#M14439
<P>Hello,</P><P>&nbsp;</P><P>Please check the component tLOBDownload:</P><P><A href="https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&amp;p=marketplace%252F1%252Fproducts%252F559&amp;pi=marketplace%252F1%252Fproducts%252F559%252Fitems%252F838" target="_blank">https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&amp;p=marketplace%252F1%252Fproducts%252F559&amp;pi=marketplace%252F1%252Fproducts%252F559%252Fitems%252F838</A></P><P>&nbsp;</P><P>It should help you with your task, but be aware, that MySQL returns BLOB as byte [], so you need to convert it to BLOB&nbsp;data type.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Výstřižek.PNG" style="width: 400px;"><img src="https://yutwg22796.i.lithium.com/t5/image/serverpage/image-id/6380iC15EBF472DD5035C/image-size/medium?v=1.0&amp;px=400" title="Výstřižek.PNG" alt="Výstřižek.PNG" /></span></P><P>&nbsp;</P>Sat, 06 Jan 2018 01:45:19 GMTlojdr2018-01-06T01:45:19ZExtract Mysql MEDIUMBLOB (Image) one by onehttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46631#M14429
<P>Hi everyone, I am new to Talend.</P><P>Now I am working on a Mysql database which have a field containing images in the data type of MEDIUMBLOB.</P><P>I know that I have to set the date type to byte[] in the schema of the Mysql table, the output is tFileOutputRaw and also need to set the dynamic file name.</P><P>But what should be the set-up so that it can export the cells (the MEDIUMBLOB field) one by one to the tFileOutputRaw?</P>Thu, 12 Jul 2018 00:48:57 GMThttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46631#M14429forfunforever2018-07-12T00:48:57ZRe: Extract Mysql MEDIUMBLOB (Image) one by onehttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46659#M14439
<P>Hello,</P><P>&nbsp;</P><P>Please check the component tLOBDownload:</P><P><A href="https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&amp;p=marketplace%252F1%252Fproducts%252F559&amp;pi=marketplace%252F1%252Fproducts%252F559%252Fitems%252F838" target="_blank">https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&amp;p=marketplace%252F1%252Fproducts%252F559&amp;pi=marketplace%252F1%252Fproducts%252F559%252Fitems%252F838</A></P><P>&nbsp;</P><P>It should help you with your task, but be aware, that MySQL returns BLOB as byte [], so you need to convert it to BLOB&nbsp;data type.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Výstřižek.PNG" style="width: 400px;"><img src="https://yutwg22796.i.lithium.com/t5/image/serverpage/image-id/6380iC15EBF472DD5035C/image-size/medium?v=1.0&amp;px=400" title="Výstřižek.PNG" alt="Výstřižek.PNG" /></span></P><P>&nbsp;</P>Sat, 06 Jan 2018 01:45:19 GMThttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46659#M14439lojdr2018-01-06T01:45:19ZRe: Extract Mysql MEDIUMBLOB (Image) one by onehttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46661#M14440
<P>Thank you very much for your help!</P><P>This is very tricky, in the future better just save the image path in the database.</P>Sat, 06 Jan 2018 10:53:19 GMThttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46661#M14440forfunforever2018-01-06T10:53:19ZRe: Extract Mysql MEDIUMBLOB (Image) one by onehttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46667#M14443
<P>You are welcome.</P><P>Saving pictures in RDBMS is not a good idea generally. There are better options where to store (e.g. some kind of Object Store).</P><P>&nbsp;</P><P>Regards</P><P>Lojdr</P>Sun, 07 Jan 2018 13:35:28 GMThttps://community.talend.com/t5/Design-and-Development/Extract-Mysql-MEDIUMBLOB-Image-one-by-one/m-p/46667#M14443lojdr2018-01-07T13:35:28Z