On Fri, 2004-01-16 at 01:21, Mark Buckle wrote:
> Does any-one have any experience in extracting image data as strings ?
> I'm trying to output the data from a table as a set of insert statements,
> one of the columns is an image column, and
> although I can successfully output the data and apparently re-load it, the
> application that uses it resolutely refuse to work
> With the transformed data.
This really depends on the DBD driver that you use, and maybe on the
underlying library.
For DBD::Sybase the default is to fetch image data as a hex string,
which means that you need to convert this to the native format with
$binary = pack('H*', $hex_string);
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] 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
