Oracle & binary serialization -- BLOB or CLOB?

[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

 

[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

 

[Brian Peasland]

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
(e-mail address removed)
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

 

[matt]

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