I have some BLOBs in a table. They're Office documents, about 50 KB in size. When I bring up the Edit Value window for the BLOB column and use the Download link, the output is truncated to 8192 bytes, so not the full document. Is there a way around this? I've tried both 19.4 and 19.1.
I've tried the Text checkbox, which I think shows me the whole document, but of course the binary characters are messed up, so I can't copy and paste from that window.
The External Editor doesn't seem to work either. Trying it gives me "For .jar file extension, External Editor can not open selected object." So it seems it's somehow associating a MIME type to the binary and coming up with .jar. OK, no biggie, I'll just associate Notepad++ to the .jar extension and open it there. No dice. It never opens the editor. Windows Notepad does work, but seems to corrupt some of the binary characters, so the BLOB is invalid.
I guess I will try to workaround and write a script and output it with utl_file, but that's a bit of a nuisance.