CODEWITHSUNDEEP
delphifirebirdfiredac
Daniel
Daniel

Reputation: 21

Delphi FireDac Fetching BLOBs

I'm using FireBird 2.5, Delphi XE3 and FireDAC components to access data from DB. Database is set to UTF8 charset. Because of maximum row size limitation 64kb in FirebBird 2.5 I'm using for some "additional information" fields type BLOB with subtype TEXT. BLOB fields slows down very much fetching data and this is clear for me and thats why in big detailed reviews i'm trying to show data faster / without blobs.

The problem is with FireDAC Query and FetchOptions->Items without [fiBlobs]. Removing [fiBlobs] from fetching items removes data also from all StringFields which size > 250 chars.

Blob fields are declared as TADWideMemoField, Varchar fields are TADStringField, so why FireDac treats StringField (i.e. VARCHAR(300)) as BLOB and how to avoid this problem? How to fetch data with all varchar fields ?

Upvotes: 2

Views: 1590

Answers (1)

tokmo
tokmo

Reputation: 1

Set this property on connection or query (it has precedence) object:

FormatOptions.InlineDataSize := MAXINT;

I tested on FireDAC ver. 7.0.1.

Upvotes: 0

Related Questions