[fpc-pascal] TStringField.Size

[Michael Van Canneyt]

On Mon, 14 Jul 2025, Luca Olivetti via fpc-pascal wrote:

> Hello,
>
> In a project I'm using both an sql server database (TMSSQLConnection) and a 
> postgresql one (TPQConnection).
> One of the TStringField is defined as size 100, but in the sql server it has 
> been changed to to 200.
> Even without changing the TStringField.Size in the program I can get values 
> longer than 100 characters.
> I did a test with the TPQConnection and if I change the size of a field, the 
> TStringField is truncated according to its size.
> Why the difference between the two database connectors? Shouldn't it depend 
> exclusively on the TField implementation?

No, the field size is calculated by the connection component and whether or
not it uses UTF8 for the character set.

Michael.