Suggestion: Try to convert BLOB in text on Sql page

[wellington1993]

Hi,

I have queries return with BLOB columns, but the BLOB is portable to String/text.
If possible try to convert BLOB to String in Select return.

The column "MON$SQL_TEXT" from is an example:
SELECT * FROM MON$STATEMENTS;

Is string but I got BLOB.

Thanks...

[wellington1993]

Hi,

I think BLOB is different of BLOB TEXT:
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref-appx05-statements.html

Thanks.

[wellington1993]

Hi,

actually i solved with separated query:
SELECT CAST(SUBSTRING(MON$SQL_TEXT FROM 1 FOR 32000) AS VARCHAR(32000)) AS SQL_TEXT FROM MON$STATEMENTS;

But is more easy do "*" select.

Thanks...