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.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
