What does TFieldDef.Size for ftString really means.
lazarus / 16-Databases

----------------------------------------------------------------------
DimProfi · 2014-07-15 09:22

Does TFieldDef.Size means maximal or fixed length for a String?


Code: [Select]ds:=TBufDataset.Create(nil);

ds.FieldDefs.Add('field 1',ftString,16);  // Reserves for EVERY Record
16 chars.
ds.FieldDefs.Add('field 2',ftString,1024);  // Reserves for EVERY
Record 1024 chars.

...

for i:=0 to 10000 do
begin
  ds.Insert();
  ds.FieldByName('field 2').AsString:='x';  // using 1024 chars or
just 1 char of memory?
  ds.Post():
end;


Chars as entity beacause of unicode

----------------------------------------------------------------------
LacaK · 2014-07-20 16:33

Quote from: DimProfi on July 15, 2014, 11:22:49 amDoes TFieldDef.Size
means maximal or fixed length for a String?
Size means maximum length in characters specified in definition of
column VARCHAR(Size)