Oracle & binary serialization -- BLOB or CLOB?

26 Oct 2006 6:32 PM

matt

hello,

does anyone know if, when inserting a serialized object into an Oracle
db, i should be using a BLOB or a CLOB?

thanks,
matt

26 Oct 2006 6:36 PM

matt

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

26 Oct 2006 6:47 PM

Brian Peasland

m***@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@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

26 Oct 2006 7:39 PM

matt

Brian Peasland wrote:

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

just had to figure out how to do in .NET. looks like the byte array is
binary data, so BLOB is what should be used. tests work, good to go.

matt