Re: How to determine file's mimetype ?
From: joel garry <joel-garry_at_home.com>
Date: Tue, 27 Sep 2011 09:30:16 -0700 (PDT)
Message-ID: <ae463ece-8e73-4536-985f-ed93786ae928_at_q26g2000vby.googlegroups.com>
On Sep 27, 5:07 am, Maikku <kangasm..._at_netti.fi> wrote:
> Hi,
> I'm uploading files from Linux to Oracle database with
> DBMS_LOB.LoadFromFile. How can I get the mimetype of the file ?
> Thanks !
>
> Maija-Leena
Date: Tue, 27 Sep 2011 09:30:16 -0700 (PDT)
Message-ID: <ae463ece-8e73-4536-985f-ed93786ae928_at_q26g2000vby.googlegroups.com>
On Sep 27, 5:07 am, Maikku <kangasm..._at_netti.fi> wrote:
> Hi,
> I'm uploading files from Linux to Oracle database with
> DBMS_LOB.LoadFromFile. How can I get the mimetype of the file ?
> Thanks !
>
> Maija-Leena
You might want to use the OS file command before loading, or are they coming from email (where you can get it from the headers) or an OS where the file extension says?
This looks kind of interesting:
http://www.techrepublic.com/article/oracle-tip-put-some-magic-into-your-database/5219073
Some googling shows there might be java class answers, too.
jg
-- _at_home.com is bogus. http://www.swpc.noaa.gov/advisories/bulletins.htmlReceived on Tue Sep 27 2011 - 11:30:16 CDT