[Solved/Invalid] Truncated BLOBs with TIBCLoader

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pmandin
Posts: 2
Joined: Tue 12 Jan 2016 08:19

[Solved/Invalid] Truncated BLOBs with TIBCLoader

Post by pmandin » Tue 12 Jan 2016 08:46

Hello,

When I import a BLOB that starts and/or ends with #0 bytes, they are not present in the field written to my database. I used http://forums.devart.com/viewtopic.php? ... 42&p=94652 as an example to import data into the BLOB.

Code: Select all

procedure TMyComponent.PutData(Sender: TDALoader);
var
  myBytes: TBytes;
begin
  SetLength(myBytes, 7);
  myBytes[0] := 0;
  myBytes[1] := 1;
  myBytes[2] := 6;
  myBytes[3] := 2;
  myBytes[4] := 0;
  myBytes[5] := 3;
  myBytes[6] := 0;

  Sender.PutColumnData(0 {index of blob field}, 0 {record number}, myBytes);
end;
After being commited, my database only contains a BLOB with bytes 1, 6, 2, 0, 3. Is there something I miss when configuring/initializing my TIBCLoader?

(IBDAC version 5.4.13 used)

[Update 20160112]
Sorry, I checked again, I was looking at the wrong place for the data I was expecting.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: [Solved/Invalid] Truncated BLOBs with TIBCLoader

Post by ViktorV » Wed 13 Jan 2016 11:43

It is good to see that the problem has been solved. Feel free to contact us if you have any further questions about IBDAC.

Post Reply