Does anybody have similar experience?

[egsuh]

Hello,

I have Firebird databases (and tables, of course). I use lot of BLOB fields to store long texts. But during the creation, some of the fields were defined as BLOB SUB_TYPE 0 (sub_type binary), and some of them as BLOB SUB_TYPE 1 (sub_type text). Practically all fields contain texts only.
With FB3.0 or below, I had no difficulty in extracting data from tables whether they were defined as text or binary.

I have migrated DB to FB4.0 (by backup and restore using FlameRobin).

Here, I have no problem in extracting data from tables within FlameRobin ISQL windows.
But I cannot extract BLOB SUB_TYPE 1 within Lazarus application (no problem with sub_type 0).  Simple select statement like

             select afield from table1 where pkid=2;

does not work, if afield is type BLOB SUB_TYPE TEXT.  Has anybody tried same thing or can anybody confirm this?