Posted by Erland Sommarskog on 04/27/06 21:36

geronimi (webjc007@hotmail.com) writes:
> Vb stores an image (bitmap/jpg) in a SQL2000 image field. For some
> reason it doubles the size by adding 00 for each byte. But sometimes it
> doesn't add 00 (0000.0000) but 01 or 20 or ?? and also the byte that
> should be transferd is changed...
> So SQLImageData = Imagebyte + 00
> and sometimes
> SQLImageData = CHANGEDImagebyte + xx.
>
> Some example data: (hex notation):
>
> A1 => A1 00
> 03 => 03 00
> -----------
> 91 => 18 20
> 83 => 92 01
> 8C => 52 01
>
> Could anybody give me an explanation, because I need to know what is
> happening, so I can remove te extra bytes added......
>
> I have already a image when I remove the extra bytes, but with some
> wrong data (on the place where things like 8C => 52 01 happen)....

Without seeing your code it's difficult to assist at all. And in any case
you may be better off to ask in a group for Visual Basic.

If this is a third-party app, I would suggest that you contact the vendor.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]