freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Insert binary data into an image column

From: Randy Syring <rsyring AT inteli-com.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] Insert binary data into an image column
Date: Sat, 16 Apr 2011 02:57:48 -0400

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] Insert binary data into an image column, Randy Syring, 04/16/2011
- Re: [freetds] Insert binary data into an image column, Frediano Ziglio, 04/16/2011