We are facing one issue. I have one table which has BLOB column defined in it.
I am trying to select the data using TD SQL assistant, but in result set its not showing correct data in column next to the BLOB column.
I tried swapping the column in my select statement, but always getting the "<error>" text in the column next to BLOB column.
Please help me here.
Which error you are actually getting?
Please find below some sample output data.
Sorry for the delays, Can you please check the max length of the data in LOB column. You can use the following query:
select ID, CHAR_length(ATCHMNT_FILE_NM) from tableName;
I doubt you may have to cast the column to max length of CLOB, as some files might being truncated during the process.