Re: Insert binary data into an image column
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Add a "0x" suffix, like insert into table(image_field) values(0x01020304) freddy77 2011/4/16 Randy Syring <[email protected]>: > I'm having a hard time figuring out how to send binary data to an image > column. I have data represented by the hex: > > 80025d7100284b014b02652e > > that I would like to insert. Note, that hex needs to be decoded to get > the data, I just encoded it to hex for the ease of posting here on the > list. > > How do I quote this and embed into an INSERT string that I can give to > dbcmd()? > > Thanks. > > -- > -------------------------------------- > Randy Syring > Intelicom > Direct: 502-276-0459 > Office: 502-212-9913 > > For the wages of sin is death, but the > free gift of God is eternal life in > Christ Jesus our Lord (Rom 6:23) > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds