Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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
>




Archive powered by MHonArc 2.6.24.

Top of Page