Storing Jpeg's in a blob field

R. Blaine Whittle

Delphi Developer

Mon, 24 Dec 2001 03:00:00 GMT

Storing Jpeg's in a blob field

Whats the best way to do this? Personnaly i dont like TDBImage for several
reasons, you can only open a couple file formates, and you can only paste
from the clipboard in a couple file formats. I do like using the standard
TImage for cut and pasting and file functions. What Im interested in doing
is saving the picture in a jpeg format instead of bmp, this will save on
compression time when looking at them through a web interface. Does anyone
know of a TJpegDBImage component? I cant seem to find one so I tried using
loadfromstream and savetostream using a TJpegImage in the hopes of allowing
any file format that TImage takes but always storing it as a jpeg in the
database. Well I cant seem blob streaming working right. Has anyone else
tried this before?

Blaine Whittle

philng

Delphi Developer

Tue, 25 Dec 2001 03:00:00 GMT

Re:Storing Jpeg's in a blob field

1) store JPeg image in a TBlobField then use TImage to display it

Procedure Tform1.ShowImage;
var
ms : TMemoryStream ;
Jpeg: TJpegImage ;
begin
Jpeg := TJpegImage.Create ;
ms : TMemoryStream.Create ;
try
Tblobfield(Table1.Fieldbyname('StoredJpegImage')).SaveToStream(ms);
ms.position := 0 ;
Jpeg.LoadFromStream(ms);
Image1.Picture.Graphic := Jpeg ; // assuming you have Image1 on
your form
finally
jpeg.free ;
ms.free ;
end;
end;

Quote

R. Blaine Whittle wrote in message <7m3f0c$i9...@forums.borland.com>...
>Whats the best way to do this? Personnaly i dont like TDBImage for several
>reasons, you can only open a couple file formates, and you can only paste
>from the clipboard in a couple file formats. I do like using the standard
>TImage for cut and pasting and file functions. What Im interested in doing
>is saving the picture in a jpeg format instead of bmp, this will save on
>compression time when looking at them through a web interface. Does anyone
>know of a TJpegDBImage component? I cant seem to find one so I tried using
>loadfromstream and savetostream using a TJpegImage in the hopes of allowing
>any file format that TImage takes but always storing it as a jpeg in the
>database. Well I cant seem blob streaming working right. Has anyone else
>tried this before?

>Blaine Whittle

Other Threads

1. JPEG error #51 - Trying to store a JPEG in a Interbase BLOB field

2. Storing a JPEG image in a paradox BLOB field

3. Print JPEG stored in paradox blob field

4. Storing Jpeg/tiff files within Blob fields

5. how to store a jpeg file in a blob field

6. Storing Memo fields in Databases (Blob Fields?)

7. Showing a JPEG stored in a BLOB

8. How to display a jpeg stored in BLOB

9. Storing JPEG into Interbase BLOB

10. Storing JPEG image into Interbase BLOB