Oracle & binary serialization -- BLOB or CLOB?

  • Thread starter Thread starter matt
  • Start date Start date
M

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
 
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
 
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
Click to expand...

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
 
Brian said:
If the data is binary, then use BLOB. Why convert binary data to a
string just to store it in a CLOB?
Click to expand...

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
 
Back
Top