in reply to Re: Inserting file into a database
in thread Inserting file into a database

About your oracle solution, why would you want to unpack and store in a clob... I would directly store the binary data in a blob... (even if i wanted to store it in a text format, i'd probably prefer to use base64, not base 16:hex )

I really cannot imagine having the data take twice it's real size (hex<=>binary).

Replies are listed 'Best First'.
Re: Re: Re: Inserting file into a database
by Ryszard (Priest) on Jan 09, 2003 at 22:12 UTC

    The 1st thing i tried was a CLOB, it worked, so i kept the solution in place (i was in a rush). I've never retrieved binary data using the DBI, so wasnt sure it would work, or how easy it would be.

    With the infrastructure in place the application performed within acceptable parameters, so I never bothered researching it further. Lazy? you bet... :-)

[reply]

In Section Seekers of Perl Wisdom