FDTable1.Fields[0].Datasize := 6 for a VARCHAR field created via an SQL statement as having a size of 5. This is using FireDAC with SQLite. Why the difference in size between what I know I created using SQL and what Fields.Datasize returns? Thanks!
http://docwiki.embarcadero.com/Libraries/XE7/en/Data.DB.TField.DataSize
This is not how the field is defined, but how much bytes is required to store it value on the client side.
--
With best regards,
Dmitry Arefiev / FireDAC Architect