CUBRID Lobs

• BLOB: Binary
• CLOB: Character LOB

CUBRIDCommand cmd = new CUBRIDCommand(sql, conn);
DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CUBRIDBlobbImage = (CUBRIDBlob)reader0;
byte[] bytes = newbyte(int)bImage.BlobLength;
bytes = bImage.getBytes(1, (int)bImage.BlobLength);
//...
}

string sql = "UPDATE t SET c = ?";
CUBRIDCommandcmd = new CUBRIDCommand(sql, conn);

CUBRIDClobClob = new CUBRIDClob(conn);
str = conn.ConnectionString; //Use the ConnectionString for testing

Clob.setString(1, str);
CUBRIDParameter param = new CUBRIDParameter();
param.ParameterName = "?";
param.CUBRIDDataType = CUBRIDDataType.CCI_U_TYPE_CLOB;
param.Value = Clob;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();