0 Replies Latest reply: Aug 10, 2017 4:01 PM by Fernando Melo RSS

    Read Firebird blob field - text in hexadecimal

    Fernando Melo

      Any Help appreciated!

      When I read a Firebird blob field containing only text in portuguese, qlik sense june 2017 returns hexadecimal value.

      I expected it to return the text as string(character).

       

      I tried to convert the hexadecimal value to character in load script like:

      SQL SELECT TO_CHAR("BLOB_FIEL") FROM FIREBIRD_TABLE - returns error:  invalid function!

      SQL SELECT SUBSTRING("BLOB_FIEL"  FROM 1 to 32000) FROM FIREBIRD_TABLE - returns error:  invalid function!


      My OS is windows 7 64 bits

      Firebird 2.5.4 64 bits


      Thanks.