Intresting Problem

[ifi]

Hello,

(sorry for my english)

I am using ADO.

I am having problem with AppendChunk and Image Field.

When ever I use AppendChunk to update an IMAGE field it stores double of the
size of value.

I mean when I use AppendChunk "ABC" on an image field it stores 6 (SIX )
bytes instead of 3 (THREE) bytes.

But when I use the same on TEXT field it work fine.


Please help me ... I want to store a .WAV file into image field



best regards

Iftikhar

[Jonathan Yang]

My explaination is only tentative.

According to VB4.0 help, there is a know bug for RDO on image data.
ADO is new that RDO, there might have been some improvements to this problem.
Probably it is using two visible chars to store one byte of image data, i.e.,
byte A1 ==> `A`, `1`.

Try peep at the image data by using "SELECT" statement to verify the aboce speculation.


On 8/7/98 11:26:55 PM, ifi wrote:
> Hello,

(sorry for my english)

I am using ADO.

I am having problem
> with AppendChunk and Image Field.

When ever I use AppendChunk to update
> an IMAGE field it stores double of the
size of value.

I mean when I use
> AppendChunk "ABC" on an image field it stores 6 (SIX )
bytes instead of 3
> (THREE) bytes.

But when I use the same on TEXT field it work
> fine.


Please help me ... I want to store a .WAV file into image
> field



best regards

Iftikhar