Re: TStringField.Size
Luca Olivetti via fpc-pascal <[email protected]>
| Newsgroups | gmane.comp.compilers.free-pascal.general |
|---|---|
| Message-ID | <[email protected]> |
El 14/7/25 a les 17:57, Michael Van Canneyt via fpc-pascal ha escrit: > > > On Mon, 14 Jul 2025, Luca Olivetti via fpc-pascal wrote: > >> El 14/7/25 a les 14:59, Michael Van Canneyt via fpc-pascal ha escrit: >> >>>> >>>> That's not what the documentation says >>>> >>>> https://www.freepascal.org/docs-html/fcl/db/tstringfield.size.html >>>> (emphasis mine) >>>> >>>> "it is the declared *maximum* size of the string (in *characters*) >>>> and is used to calculate the size of the dataset buffer." >>> >>> Seems the documentation has not been updated for the unicode case :-( >> >> Well, even the "maximum" part isn't true, at least using the >> TMSSQLConnection. > > How so ? the size comes from what is reported by MSSQL. Well, in both cases (using TMSSQLConnection and TPQConnection) I have specified the size of the TStringField in the object inspector. When using the TMSSQLConnection the size I specified seems to be ignored (i.e. I have set it to 100, the field has been changed to varchar(200) and I get more than 100 characters) while with TPQConnection the length is truncated (i.e. even if I change the field to varchar(200) any record with a value longer than 100 characters is truncated to 100 characters). Again, the documentation says "Size is made published by the TStringField class so it can be set in the IDE" and I expected that to be the case, which it true with TPQConnection but false with TMSSQLConnection. Bye -- Luca _______________________________________________ fpc-pascal maillist - [email protected] https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal