Text Into a BLOB Field

[rhill#wfubmc.edu]

I need to insert text into an Oracle 9i BLOB field. I
assume there will have to be some conversion to binary
for this to occurr. I have tried to update the BLOB
field with text from a textbox and have not been
sccessful. Can anyone point me in the right direction???

Thanks,

Robert

 

[Miha Markic]

Hi,

The DataColumn should by of byte[] datatype.
To encode string to bytes you shold do something like:
string s = "Tubo";

Encoding e = new UTF8Encoding();

byte[] b = e.GetBytes(s);

To decode (where b is byte[])

string sx = e.GetString(b);

And here is the parameter declaration:

this.oracleInsertCommand1.Parameters.Add(new
System.Data.OracleClient.OracleParameter(":TEST",
System.Data.OracleClient.OracleType.Raw, 0, "TEST"));

HTH,

 

[Paul Clement]

¤ I need to insert text into an Oracle 9i BLOB field. I
¤ assume there will have to be some conversion to binary
¤ for this to occurr. I have tried to update the BLOB
¤ field with text from a textbox and have not been
¤ sccessful. Can anyone point me in the right direction???
¤

BTW, you should be using a CLOB instead of a BLOB for text based data.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)