PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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).

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