2015 era sqllite app doesn't display field.

[marcov]

I've an 2015-2017 era sqldb-with-sqllite app that is for some personal administration. I had to update it, and saw that a field wasn't showing anymore. (with the same original DLL)

The field is ftfixedchar with size 128 and precision -1, and it is a simple query  (select * from tablename).  Any idea what that could be? something changed in the handling of string types?

[paweld]

You didn't mention which version of FPC you are using. But if it's trunk, 3.2-fixes, or 3.2.4rc1, the cause may be the patch from issue : https://gitlab.com/freepascal.org/fpc/source/-/issues/40686
The symptom is the field type set as ftMemo.

[rvk]

Any idea what that could be? something changed in the handling of string types?

Yes. Something has changed.
TEXT fields are now treated as ftMemo as in the past they were treated as ftString.

I think this was a wrong decision but it was done.

It would have been better to fix the FTS-Tables issue instead of generally change this for all tables.

[marcov]

fpc trunk/lazarus trunk, I tried setting the field to ftmemo, ftstring or ftfixedchar, and it doesn't display values in the grid either way.

[PascalDragon]

If I remember correctly then you need to set some option in the grid that allows it to display memo fields (dgDisplayMemoText in Options).