Re: Oracle & binary serialization -- BLOB or CLOB?

matt_at_mailinator.com wrote:
> i should mention this is binary serialization.
>
> i gotta figure out the proper column type for it, and then how to get
> it there. if its BLOB, i believe i can pass in the memory stream as a
> blob parameter. if its clob, then i think i need to conver it to a
> string first.
>
>
> matt
>

If the data is binary, then use BLOB. Why convert binary data to a string just to store it in a CLOB?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown