|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: blob image data via DBD::Sybase
Date: Apr 26 2003 12:49AM
On Fri, 2003-04-25 at 10:16, Lee Wenzler wrote:
> Hello all:
>
> I'm using Sybperl on Sybase 12 (no problems on that side) and also
> DBD::Sybase (version 0.94) to connect to a SQL 2000 server. I'm
> writing a script that transfers print published material from a Sybase
> db to an SQL 2000 web publication db. Using the two modules have
> worked fine for transferring text data, but now that I'm trying to add
> jpeg blob images from Sybase and send them to SQL 2000, it looks like
> the DBD::Sybase module sees the image data as a character string and
> barks because of the quotes. Here's the first method I've used:
>
> ... $graphic gets filled with a graphic (I know that's working, I can
> write it to a file and it displays fine in a browser).
Hmmm.
Have you tried inserting the image as a hex string directly in the
insert statement?
What libraries are you using with DBD::Sybase (freetds?)
Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html
|
