topic Read Firebird blob field - text in hexadecimal in App Development https://community.qlik.com/t5/App-Development/Read-Firebird-blob-field-text-in-hexadecimal/m-p/1383880#M31631 <HTML><HEAD></HEAD><BODY><P>Any Help appreciated!</P><P>When I read a Firebird blob field containing only text in portuguese, qlik sense june 2017 returns hexadecimal value.</P><P>I expected it to return the text as string(character).</P><P></P><P>I tried to convert the hexadecimal value to character in load script like:</P><P>SQL SELECT TO_CHAR("BLOB_FIEL") FROM FIREBIRD_TABLE - returns error:&nbsp; invalid function!</P><P><SPAN style="font-size: 13.3333px;">SQL SELECT SUBSTRING("BLOB_FIEL"&nbsp; FROM 1 to 32000) FROM FIREBIRD_TABLE - returns error:&nbsp; invalid function!</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">My OS is windows 7 64 bits</SPAN></P><P><SPAN style="font-size: 13.3333px;">Firebird 2.5.4 64 bits</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks.<BR /></SPAN></P></BODY></HTML> Thu, 10 Aug 2017 20:01:30 GMT Anonymous 2017-08-10T20:01:30Z Read Firebird blob field - text in hexadecimal https://community.qlik.com/t5/App-Development/Read-Firebird-blob-field-text-in-hexadecimal/m-p/1383880#M31631 <HTML><HEAD></HEAD><BODY><P>Any Help appreciated!</P><P>When I read a Firebird blob field containing only text in portuguese, qlik sense june 2017 returns hexadecimal value.</P><P>I expected it to return the text as string(character).</P><P></P><P>I tried to convert the hexadecimal value to character in load script like:</P><P>SQL SELECT TO_CHAR("BLOB_FIEL") FROM FIREBIRD_TABLE - returns error:&nbsp; invalid function!</P><P><SPAN style="font-size: 13.3333px;">SQL SELECT SUBSTRING("BLOB_FIEL"&nbsp; FROM 1 to 32000) FROM FIREBIRD_TABLE - returns error:&nbsp; invalid function!</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">My OS is windows 7 64 bits</SPAN></P><P><SPAN style="font-size: 13.3333px;">Firebird 2.5.4 64 bits</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks.<BR /></SPAN></P></BODY></HTML> Thu, 10 Aug 2017 20:01:30 GMT https://community.qlik.com/t5/App-Development/Read-Firebird-blob-field-text-in-hexadecimal/m-p/1383880#M31631 Anonymous 2017-08-10T20:01:30Z