FireDac variable column length overflow

[Jeff Steinkamp 1]

 I am getting this error anytime the county field length seems to exceed 20.   In the table structure, that field is defined as a VARCHAR(32).  So, what is truncating this field to a maximum length of 20, and how do I fix this.  I can set StrsTrim2Len and that will eliminate the error and truncate the data in the field to 20 characters, but that is not the behavior I want.

 

The database is SQLite.

[programmerdelphi2k 237]

https://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Stan.Option.TFDFormatOptions.StrsTrim

look in your component to query the properties about field size on Fields editor

 

Edited December 3, 2022 by programmerdelphi2k

[Fr0sT.Brutal 900]

What value are you trying to assign? My bet is on non-latin chars which being encoded to UTF8 increase total byte length