Re: Saving and Retrieving BLOBs

Mark Wallace a écrit :
>
> I am using VB 6.0 to save a binary file to a blob column on the database.
> Using AppendChunk to save and GetChunk to retrieve.
>
> All works ok and the binary file is saved successfully to the database. I
> can also retrieve the file with no problems.
> Except for ....!!!
>
> When I retrieve the file from the database and write it back to the
> Operating System again it is now a couple of bytes bigger than it was
> originally?
>
> Any reason for this.
>
> So far the file seems to be accessible as normal, but I am still worried as
> to why it is a different size.
>
> Writing to Win NT 4.0 Operating system.
>
> Thanks
> Mark

I experienced a problem which sounds like this one. When writing a BLOB or a CLOB in a column where a longer data was stored, I get back data with the original length.
I posted a message on this forum on Monday, May, 28 "Updating CLOBs and BLOBs". I did not get any answer.
Please let me know if your problem is the same one.

Roger Leriche.

-- 
info_at_abaksystemes.fr
ABAK Systèmes, ZI Le Rachat - BP 5 - 35890 LAILLE
Tel: +33(0) 299.42.30.10, Fax: +33(0) 299.42.31.57