The blob format of Firebird is a bit tricky.
First of all for custom made blob types, use negative numbers. For each type
of content use different type of blob type.
So for JPEG use -1, bitmapt -2 etc...

That way, it stores better and faster the content of the blob.
If you just want to save "data" that is not common structure on all records,
then you will not "enjoy" the performance you are looking for.

Ido
http://ik.homelinux.org/

On Tue, Jul 27, 2010 at 10:56, trskopo <trskopo@...> wrote:

>
>
> Hi all,
>
> Just want to make sure, it seem Firebird 2 doesn't support jpeg type. I
> tried to store jpg format and it raised an error message.
>
> If store in bmp format, it was ok. Is there any devolopment in the future
> to support jpg format? What kind of format support by blob sub type 0 (to
> store graphic) other than bmp?
>
> Thanks and regards,
> Sugiarto
>
>
>


[Non-text portions of this message have been removed]