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.