Does anybody have similar experience?
lazarus / 16-Databases

----------------------------------------------------------------------
egsuh · 2022-10-26 09:43

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?