Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

fernandomelo
New Contributor

Read Firebird blob field - text in hexadecimal

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.

Tags (1)