freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Insert binary data into an image column

From: Frediano Ziglio <freddy77 AT gmail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Insert binary data into an image column
Date: Sat, 16 Apr 2011 14:10:42 +0200

Add a "0x" suffix, like

insert into table(image_field) values(0x01020304)

freddy77

2011/4/16 Randy Syring <rsyring AT inteli-com.com>:
> 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

[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