Does anyone know if a visual basic string data type can be converted
to DB2 blob datatype?

I have all data in XML files and I use Visual Basic to read the
characters from the XML file and insert into the DB2 database. For
most common datatypes, the conversion from VB to DB2 is easy, example,
CInt to convert VB string to integer, CDbl to convert VB string to
double, etc.

But is there a way to convert from VB string to insert to a BLOB
(binary large object data type) field in DB2?

Thank you very much!

VB string is automatically converted to CLOB when necessary, but you need to
remember that a VB string is UCS-2 Unicode, whereas CLOB is 8-byte
character. To convert to BLOB you'll need to turn the VB string into a
byte(). This will depend upon whether you're using the string to hold raw
dataas is, or whether you've expanded each byte to two bytes because you're
atually storing ASCII in Unicode strings. You may also need to consider
whether your input is not Unicode to start with (you said XML). Review the
VB StrConv BIF for details.

Since you're starting with XML, which is character data, I would strongly
recommend your using a CLOB rather than a BLOB field.

Finally, Bruce McKinney's VBCore provides an amazing component, with
complete VB source code for a mass of useful tasks, including various
routines for handling all sorts of binary conversions. See
http://archive.devx.com/upload/free/...mckinney2a.asp.
The book that describes the code can be bought used from Amazon and is
highly recommended (especially if you need help understanding the vbcore
code).

"sea" <sea_099 (AT) hotmail (DOT) com> wrote