I need to convert BLOB data to a string. There is this BLOB data which is a combination of string and media files. I know we won’t be able to see media data as string. But at least I need to see the text part in the BLOB data. I have this java code to convert BLOB to a byte array and then I am using “bytesToString” service. But its not giving me the output as required. Output is displayed like 0 | 0 | |E || .
BLOBs are binaries. To convert it to string you need to understand how it was created (format of the BOLB). For example, first 20 bytes may represent string, next 50 represents java object etc. Then get the first 20 bytes in a byte array and convert it to string.
I have a similar problem, wherein i insert the BLOB data into database using the JDBC adapter and while retrieving the BLOB data from the database, i am facing problems while converting the same to string.