Issue in converting Binary datatype(BLOB in mysql) to String
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,
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