Read Firebird blob field - text in hexadecimal

[Anonymous]

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.