I am using the LiteDAC 4.3.2 and Delphi 10.4.1 and I have some blob fields in my sqlite3 that I store binary data and I am having problems with these fields.
To write I use:
Code: Select all
ADataSet.ParamByName('xxx').AsBytes
To read I use:
Code: Select all
ADataSet.FieldByName('xxx').AsBytes
The write is apparently working correctly, but the read is not and from what I noticed internally LiteDAC is considering the BLOB field as a string (In TField, the FDataType is ftWideString), and that's a problem.
This happened to me on MyDAC, but there were options that I set to work around this problem:
Code: Select all
TCustomMyDataSet(ADataSet).Options.FieldsAsString := False;
TCustomMyDataSet(ADataSet).Options.BinaryAsString := False;
But in LiteDAC I didn't find that option. How can I work around this?
(Sorry for my bad english)