they are not exactly encrypted, but they ARE compressed. That's why you could not just extract the binary data and open the file. But that's also the reason that a 30MB word doc only occupies a fraction of that once stored in the database... If you'd extract the attachment using the API it would uncompress the file nicely. -- Michiel
On 7/30/06, Jason McDonald <[EMAIL PROTECTED]> wrote:
** Hi All, I wanted to know how Remedy (7.0) stores LOB data. I was trying to extract directly from the database a BLOB field (attachment in remedy ; in this case it was a PDF file) but although I knew the MIME type and opened it in a special tool designed to extract BLOB data, Acrobat Reader refused to open it (it said invalid file). Further, following the same process as above, even if I open a 'text file' attachment, the contents seem to be encrypted and I see junk data when opening it in Notepad. Are attachments encrypted by Remedy before storing it in the database? If so, how do I bypass remedy and view BLOB data? (Dev Env) ARS 7.0 Oracle 10g OS - Windows Thanks, Jason __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
