OraFAQ Forum: SQL & PL/SQL » Base64 String to Image

Home » SQL & PL/SQL » SQL & PL/SQL » Base64 String to Image (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Base64 String to Image [message #388611]

Wed, 25 February 2009 12:12

2jhenry01
Messages: 4
Registered: February 2009

Junior Member

Hello-

I need to pull BLOBs (stored as Base64 strings) from our database and store as bitmap images externally.

Can anyone offer some direction here? I'm not sure how to do this using only PL/SQL.

I did try to convert the BLOB using UTL_ENCODE.base64_decode and then using UTL_FILE.put_raw to write the new file out. The file is written but is unreadable.

Please help?

TIA!

Report message to a moderator

Re: Base64 String to Image [message #388615 is a reply to message #388611]

Wed, 25 February 2009 12:19

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

BLOB is binary and so not handle by Oracle.
Only YOU know what is its format and how to read it.

Regards
Michel

Report message to a moderator

Re: Base64 String to Image [message #388621 is a reply to message #388615]

Wed, 25 February 2009 12:56

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://fdegrelle.over-blog.com/article-12589417.html

Report message to a moderator

Re: Base64 String to Image [message #388633 is a reply to message #388611]

Wed, 25 February 2009 13:49

2jhenry01
Messages: 4
Registered: February 2009

Junior Member

Thank you both for your responses.

I'm able to write the external file just fine. But it's not readable as a bitmap. I guess I'm confused as to what I need to convert it to?? As I said, it's being stored in the BLOB column as a Base 64 String. I thought by decoding that into a RAW type that I could write it out to a file with a .BMP extension and it would be fine. That hasn't worked though.

Can you provide further direction?

Report message to a moderator

Re: Base64 String to Image [message #388637 is a reply to message #388611]

Wed, 25 February 2009 14:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The file is written but is unreadable.
What software utility is being used to open & read the resultant file?

Report message to a moderator

Re: Base64 String to Image [message #388638 is a reply to message #388611]

Wed, 25 February 2009 14:25

2jhenry01
Messages: 4
Registered: February 2009

Junior Member

I'm just trying to open the file (.bmp) using Paint in Windows.

Report message to a moderator

Re: Base64 String to Image [message #388641 is a reply to message #388611]

Wed, 25 February 2009 14:40

2jhenry01
Messages: 4
Registered: February 2009

Junior Member

If the data I'm trying to convert was encoded to base64 by an outside application (C++ code) and inserted into the database ... will the UTL_ENCODE.base64_decode be able to convert this to it's original binary format?

Report message to a moderator