https://community.qlik.com/t5/Talend-Studio/How-to-convert-BLOB-to-String-or-table-of-content/m-p/2244380#M30548 hi<BR />Can somebody provide the procedure to convert BLOB which is java object stored in MYSQL database to String or table of content<BR />Thanks &amp; Regards<BR />Bharath Sat, 16 Nov 2024 10:49:02 GMT Anonymous 2024-11-16T10:49:02Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-BLOB-to-String-or-table-of-content/m-p/2244380#M30548 hi<BR />Can somebody provide the procedure to convert BLOB which is java object stored in MYSQL database to String or table of content<BR />Thanks &amp; Regards<BR />Bharath Sat, 16 Nov 2024 10:49:02 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-BLOB-to-String-or-table-of-content/m-p/2244380#M30548 Anonymous 2024-11-16T10:49:02Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-BLOB-to-String-or-table-of-content/m-p/2244381#M30549 Hi&nbsp; <BR />Using a tMysqlInput to read the data from mysql table, select 'byte[]' from the Type list and select 'Blob' from the DB type on the schema of tMysqlInput, and then convert byte[] to string on a tMap, eg: <BR />tMysqlInput--main--tMap--out1--tLogRow <BR />on tMap, set the expression of column in the output table: <BR />new String(row1.blobColumnName) Thu, 18 Feb 2016 10:02:06 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-BLOB-to-String-or-table-of-content/m-p/2244381#M30549 Anonymous 2016-02-18T10:02:06Z