Jump to content
Sign in to follow this  
Mark-

FireDAC TFDQuery not fetching complete string...

Recommended Posts

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 by Mark-

Share this post


Link to post

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

Share this post


Link to post

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 by Mark-

Share this post


Link to post

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.

 

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×