Hi,
I have a table containing blob column.
There are some records in the table and the blob column contains .jpg,
..gif, .doc files.
I dont have filename stored in database which have the extension.
When I take the blob column throug java, how do I know whether the
respective blob is a gif file or jpg file or some other file.
Please let me know if you have any idea.

Milind

Thanks alot,
But we dont have interMedia.
Is there any other way to find out what is the type present in blob
(jpg, xls, gif, png etc)??

Milind

Well, you may try to employ signature checks (the same
way mod_mime_magic Apache module does) - use a
list of known file format signatures, compare them to the
first few bytes of the LOB to detect file format.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

<milindsj@gmail.com> wrote in message news:1143789838.448325.125190@u72g2000cwu.googlegr oups.com...

> Thanks alot,
> But we dont have interMedia.
> Is there any other way to find out what is the type present in blob
> (jpg, xls, gif, png etc)??
>
> Milind
>

milindsj@gmail.com wrote:
> Thanks alot,
> But we dont have interMedia.
> Is there any other way to find out what is the type present in blob
> (jpg, xls, gif, png etc)??
>
> Milind
>
Or rethink your design, and *store* the mime type

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

milindsj@gmail.com wrote:
> Thanks alot,
> But we dont have interMedia.
> Is there any other way to find out what is the type present in blob
> (jpg, xls, gif, png etc)??
>
> Milind

Why don't you think you have interMedia?

Q: Do I have to buy a separate option or license to do it?
No. Oracle10g includes a component called interMedia that makes it
possible to manage digital media. interMedia is a component of the
Oracle Database and is included in Oracle Database licensing.

Source:
http://www.oracle.com/technology/pro...media_faq.html
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

On Thu, 30 Mar 2006 23:23:58 -0800, milindsj wrote:

> Thanks alot,
> But we dont have interMedia.
> Is there any other way to find out what is the type present in blob
> (jpg, xls, gif, png etc)??

interMedia is included in the Standard and Enterprise editions of the
database (since 8.0) at no additional charge.

You say you have no interMedia ... Have you removed interMedia from the
database?

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***

On Fri, 31 Mar 2006 23:07:57 +0800, Frank van Bortel wrote
(in article <e0jfql$a6m$5@news6.zwoll1.ov.home.nl>):

> milindsj@gmail.com wrote:
>> Thanks alot,
>> But we dont have interMedia.
>> Is there any other way to find out what is the type present in blob
>> (jpg, xls, gif, png etc)??
>>
>> Milind
>>
> Or rethink your design, and *store* the mime type
>
>

Intermedia is not a solution in this situation. you still must store the
Extension/mime type.

steve


--
NewsGuy.Com 30Gb $9.95 Carry Forward and On Demand Bandwidth

On Sat, 01 Apr 2006 18:19:06 +0800, steve wrote:

>
> Intermedia is not a solution in this situation. you still must store the
> Extension/mime type.
>

Please explain - why will the interMedia getMimeType( ) not work in this
case?

http://download-east.oracle.com/docs...f.htm#sthref81

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***