At 11:34 AM 17/02/2005 +1000, you wrote:

>Im having an issue with the conversion of bmp, png, jpeg image fields in
>SQL Server being converted to Blob type field in firebird, my application
>{Delphi 7} cannot read the converted fields, i believe i am converting the
>relevant field to a Blob sub type which can store the image data but when
>the application attempts to read the FileData field {this is the blob type
>field} it causes a 'Stream Read Error' going on to finally say the data is
>corrupt ??? does this make sense to anybody ??

Firebird's non-text blob stores exactly what is given to it. It doesn't
know what it is writing or reading, other than "a stream of bits".

Are you picking up specialised binary datatypes from SQLServer and simply
copying them bit-for-bit to binary blob? SQLServer probably has OS and
DBMS specific headers stored on these objects. It's doubtful this would get
read back as a valid image file by your format-aware application... As a
minimum I think you'd need some intermediate conversion layer that converts
these typed objects back to the original image files, in order to strore
them "value-free" into binary blobs.

What's the environment you are using to do what you're doing currently?

./heLen