FireDAC TFDQuery not fetching complete string...

[Mark- 29]

Hello,

 

Delphi 10.2 connection to MySQL 8.0.18

 

The TFQuery fetching is controlled by a TDBGrid. The table has 5 records.

 

I have a TFDQuery accessing a table. For the most part no problems. Two table fields are “TEXT” and have about 400 characters per record.

 

The TFDQuery is not fetching or at least not allowing me to get all the characters. For example, one field is 432 characters and accessing the text with .filedValues or .fieldByName.asString or any of the “as” text only returns 308 characters. The break is not on anything weird, in this instance the break is between an “n” and “e”.

 

Looking over all the properties of TFDQuery and TDBGRid, everything seems fine and not limiting the fetch.

 

Ideas?

 

Thanks,

 

Mark

Edited July 23, 2020 by Mark-

[ergeka 5]

Had a similar issue with TFDQuery and MariaDB.

Blob fields were not read completely due to an outdated 'libmariadb.dll'.
So maybe it's worth to make sure 'libmysql.dll' is up to date.

 

Regards,

 

Ralf

[Mark- 29]

Ralf, thanks for the response. I am using ODBC and updated the driver from 8.0.10 to 8.0.21, no joy.

 

I did find if I issue an SQL statement for a specific record all the data for the fields is returned. 

Edited July 23, 2020 by Mark-

[Mark- 29]

Not sure where the problem is located. Changed the column type from TEXT to VARCHAR(4095) and now all the characters are fetched.

Anyone used the TEXT data type of MySQL with FireDAC (using ODBC) and a DBGrid?

 

When the type is TEXT is appears in the grid as {WIDEMEMO}. Perhaps a setting I am missing that limits the fetch size for WIDEMEMO.