Janet,
If you've read the image file in, (either from the filespace, or
received it via an upload) then you can just store that directly in a
BLOB column. If you want, you can BASE64 the data via @cipher, which
will turn it into text, but that typically results in a 15% increase
in data size, just so that you can use a CLOB (character large object)
column.
Be aware of your MaxItemBufferSize, which will truncate the data
retrieved from the database. If you are using BLOBS, it isn't hard to
then use offsets to retrieve the BLOB in several parts, each less than
MaxItemBufferSize.
Regards,
Jason.
On 01/05/2008, at 10:55 AM, Janet wrote:
Thank you William
I guess I am stuck because I read that a byte array is used to send
data to
an Image field. So I was looking for a utility that would convert
the image
file into a byte file. I found code samples on the web but I was
hoping to
find a utility. Mostly I use excel files to load data into MS SQL.
I mean I am clueless when I think about getting the image file into
the
table field.
Janet
WITH IMAGINATION
Planning, Implementation and Management of Web Applications
Level 1, 44 Miller Street North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email - [EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by ESVA, and is
believed to be clean.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
