[Solved/Invalid] Truncated BLOBs with TIBCLoader
Posted: 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.
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.
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;(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.