topic Re: Issue in converting Binary datatype(BLOB in mysql) to String in Talend Studio

Issue in converting Binary datatype(BLOB in mysql) to String

Anonymous — Sat, 16 Nov 2024 10:04:26 GMT

Hi,
We are retrieving data using tmysqlinput. For a particular column we want to convert the binary(BLOB datatype in mysql DB) datatype to string and store it into mysql database.Please let us know how to convert it.
Thanks,

Re: Issue in converting Binary datatype(BLOB in mysql) to String

Anonymous — Thu, 16 Feb 2017 09:18:59 GMT

Hi,
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:
tMysqlInput--main--tMap--out1--tLogRow
on tMap, set the expression of column in the output table:
new String(row1.blobColumnName)
Let us know if it is OK with you.
Best regards
Sabrina

Re: Issue in converting Binary datatype(BLOB in mysql) to String

Anonymous — Thu, 16 Feb 2017 10:10:25 GMT

Hi,
We have tried as per your suggestion we got [B@5f341870 like this records.but that column contains 16 digits uuid.
Thanks,

Re: Issue in converting Binary datatype(BLOB in mysql) to String

Vinnie_Pisaniello — Thu, 09 Jun 2022 14:28:57 GMT

having the same issue moving data from MS SQL server, on a column that is data type binary (length 20). Anyone have an answer for this?