SQL Server query with Image datatype

[Fresh Air Rider]

Hi Folks

Can anyone please tell me how I can safely run an SQL query on SQL
2000 via a Perl which includes a field of Image datatype which holds
images stored in the database ?

Every time I add the Image field to my query, it causes Perl to
perform an illegal operation.

Thanks
John

[Michael Peppler]

On Thu, 26 Jun 2003 13:26:18 -0700, Fresh Air Rider wrote:

> Hi Folks
>
> Can anyone please tell me how I can safely run an SQL query on SQL 2000
> via a Perl which includes a field of Image datatype which holds images
> stored in the database ?
>
> Every time I add the Image field to my query, it causes Perl to perform an
> illegal operation.

You probably need to set the TEXTSIZE to some reasonable value. IIRC
MS-SQL defaults this to 2GB. You can use
$dbh->do("set textsize <somevalue>");
to set this to <somevalue> bytes.

Michael
--
Michael Peppler Data Migrations, Inc.
[email]mpeppler@peppler.org[/email] [url]http://www.mbay.net/~mpeppler[/url]
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - [url]http://www.mbay.net/~mpeppler/resume.html[/url]

[Fresh Air Rider]

Thanks very much for that Michael, I give it a try.

John