I have a requirement where I have to convert the data from the Blob in the database to textual content. Please help me regarding this issue.
Thanks in advance
Simply use a :
- SQL Query Activity (the blog will appear as 'IO' in the output)
- Transform the binary to string using the tib:base64-to-string($JDBC-Query/resultSet...).
If you want to write data into to the blob field, tib:string-to-base64 function(inputString).
Hope this helps.
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer