Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

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).


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 Peppler                              Data Migrations, Inc.       
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions -