Re: Blob scrambling

If text use CLOB ... not BLOB.

Daniel Morgan

Not Me wrote:

> Hey group,
>
> I'm testing out my BLOB setup by inserting a small amount of text and then
> trying to pull it out. Each time I get the right length of data (about 69
> bytes) but the content of that data is well scrambled.
>
> I'm using Delphi 5 with the standard ADO recordset methods .AppendChunk and
> .GetChunk, and using Oracle's own ODBC provider (MS provider didn't get me
> anywhere near this). I'm also validating that the information uploaded is
> correct, and it always is; I've even tried base 64 encoding the data to see
> if using the reduced ASCII-only character set might help and it doesn't.
>
> I've done bit-by-bit comparisons with the information as it goes in vs. when
> it comes out and I can't discern any patterns there (but that's probably not
> much of a surprise). Any help would be very appreciated!
Received on Tue Mar 19 2002 - 23:51:49 CET