How to store large amounts of text in an SDE table

Question

I need to store a lot of text in a field in an SDE registered business table (an ITable, not a featureclass) - let's say 10,000 words roughly. I am using Oracle 10g and ArcSDE 9.1.

I am programming with ArcObjects 9.2 sp6.

It looks like the only option might be to use a BLOB as a CLOB is not usable with 9.1 (shame).
Can you use a BLOB in this way and how would you do it in ArcObjects code?

Answer 1

Yes, you can use either a Blob or LONG_RAW per the docs edndocs to support a huge block of text, you really want to make sure you parse your text well before it goes in so you don't have any compromised information in the string.

You will have to handle the storing yourself; since its looking like that assumes you are inserting something binary.

Answer 2

I think I have some kind of solution - but not sure if it's that elegant, but nothing else jumps out.

Does this look right to you?, your feedback is welcome.

StrArray strArray = new StrArrayClass();
strArray.Add("This is a load of mumbo jumbo that goes on for ages...");
IPersistStream persistStream = (IPersistStream)strArray;
IMemoryBlobStream2 memoryBlobStream = new MemoryBlobStreamClass();
persistStream.Save(memoryBlobStream, 0);
rowBuffer.set_Value(fooIndex, (System.Object)memoryBlobStream);