Huh?

I thought anything could be stored in blob subtype 0, that Firebird doesn't care about the content (well, possibly excepting the size, but your jpeg isn't that huge) and that it is up to whatever components you use to interpret what is stored there. Whether you store bmp, jpeg, wav, entire programs or even viruses in a blob subtype 0 is irrelevant for Firebird, it doesn't know and doesn't try to interpret what is stored in such a field.

My guess is that it is your components that support bmp, but not jpeg, and that the problem has nothing to do with Firebird.

Do things work if you store them in a file rather than in Firebird - i.e. can you store and read jpeg in a file using the same components as you use with Firebird? If so, what is the error message you get when using Firebird?

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of trskopo
Sent: 27. juli 2010 09:56
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Is blob sub type 0 doesn't support JPEG type?

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