How To Convert Blob Data To String In Db2. This method can only be used to retrieve data from a DB2Blob ins
This method can only be used to retrieve data from a DB2Blob instance once. arrayToString (conn. The result can be null; if the first argument is null, the result is the null value. Aug 23, 2018 · A table in DB2 contains BLOB data. I need to convert it into String so that it can be viewed in a readable format. If you want to convert this to a string using the platform encoding, var str = system. If you have already used the Value property or the GetBytes method to retrieve data from a DB2Blob instance, you cannot use The result of the function is a BLOB. lang. If you use this method to retrieve data from a DB2Blob instance, you cannot use the Value property or the GetBytes method to do the same. Returns a string that represents the DB2Blob structure. Using TDI/SDI, a blob will be returned as a byte array. String (conn. getObject ("x")) var str = java. I tried options like getting blob object and converting to byte array string bu Returns a string that represents the DB2Blob structure. Mar 20, 2019 · Is it possible to do this with a cast? If it is what will the syntax be? My problem that I have is a system stores text data in a blob field and I want to use a select statement to see what the text data is in the blob field. If you have already used the Value property or the GetBytes method to retrieve data from a DB2Blob instance, you cannot use Learn how to efficiently convert DB2 BLOB data containing hexadecimal or text representations to ASCII. DB2 BLOB to ASCII. This guide covers various methods and troubleshooting. Db : Db2 on Ibm Edit: I have managed to covert the string to the hex value by using :. getObject ("x"), "UTF-8") Thank for your reply jan i have converted BLOB to Json. now i need to parse that Json object to Excel. The actual length of the result is the minimum of the length attribute of the result and the actual length of string-expression (or twice the length of string-expression when the input is graphic data).